On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote:
>> --- JOE TESTA <[EMAIL PROTECTED]> a écrit :
>> In a "normal" time_dimension, doesn't qtr need to
>> have the year as part of it, so that it looks like
>> 20011 for the 1st qtr?
> Let the quarter field contain only quarter
> information.
Yes, you can query the year field if needed.
> It will be easier to compare data between quarters
> over years.
You may want to have an extra column for each column listed which
has a "julian" number.
Jul-Qtr Qtr
1 1
2 2
3 3
4 4
5 1
6 7
Then, you can do some nice comparisons across quarters with just
straight arithmetic.
Then, each one of the columns could have this extra column for
good measure.
> If users want to see data for a year, they will
> specify it.
--
Galen Boyer
It seems to me, I remember every single thing I know.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Galen Boyer
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
