Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Cube with two time dimensions

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Cube with two time dimensions Empty Cube with two time dimensions

Post  hesh Mon Jul 16, 2012 9:17 am

Hi,

My requirement is to build a cube with two time dimensions, my data looks like this...

PRODUCT_NO NUMBER,
IN_RANGE VARCHAR2(1),
VALID_FROM DATE,
VALID_TO DATE

the two date columns will be mapped to time dimension to get dimension keys.

Any clues please?


Thanks,
Hesh

hesh

Posts : 12
Join date : 2011-08-16

Back to top Go down

Cube with two time dimensions Empty Re: Cube with two time dimensions

Post  ngalemmo Mon Jul 16, 2012 2:43 pm

If you need to include attributes of the time dimension, then store two time dimension FKs with different names. If you don't need time dimension attributes, then just store the dates.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Cube with two time dimensions Empty Re: Cube with two time dimensions

Post  hesh Tue Jul 17, 2012 2:50 am

Thanks Ngalemmo for your valuable response


hesh

Posts : 12
Join date : 2011-08-16

Back to top Go down

Cube with two time dimensions Empty Re: Cube with two time dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum