Joe,
If you had only 1..4 values for quarters you can
compare quarters across years or to each other in your
SQL queries. If users wanted to compare particular
quarters e.g year 2000 Q1 to year 1999 Q4 they could
always use both Year and Quarter fields in the
queries. However if they wanted to compare Q1 in last
5 years with Q2 or Q3 over the same period you will
make their life in the quering tool difficult.
You'd be better off using 1..4 or Q1..Q4 values over
20011 etc.
--- JOE TESTA <[EMAIL PROTECTED]> wrote:
> my latest assignment takes me into the world of DW.
>
> the dm_time table has:
>
> dm_time_id number
> ..
> ..
> ..
> sales_year number(4)
> sales_qtr number(1)
> sales_month number(2)
> sales_week number(2)
> sales_day number(3).
>
> so an entry looks like: time_id 10456
> sales_year=2001
> sales_qtr=1
> sales_month=1
> sales_week=1
> sales_day=1
> to rollup the data we define dimensions. I was
> asked this:
>
> 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?
>
> thanks, joe
>
=====
Sundeep Maini
Consultant
Currently on Assignement at Marshfield Clinic WI
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sundeep maini
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).
