Re: dimension time question

On Mon, 13 Aug 2001, stephane_paquette_at_yahoo.com wrote:

>> --- JOE TESTA <JTESTA_at_longaberger.com> 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: galenboyer_at_hotpop.com

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: ListGuru_at_fatcity.com (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).