Re: dimension time question

From: sundeep maini <sundeep_maini_at_yahoo.com>
Date: Sun, 12 Aug 2001 15:12:43 -0700
Message-ID: <F001.0036881B.20010812151521@fatcity.com>

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 <JTESTA_at_longaberger.com> 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 mainis_at_mfldclin.edu

---

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: sundeep_maini_at_yahoo.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).

Received on Sun Aug 12 2001 - 17:12:43 CDT