Cube with two time dimensions

View previous topic View next topic Go down

Cube with two time dimensions

Post  hesh on 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

View user profile

Back to top Go down

Re: Cube with two time dimensions

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Cube with two time dimensions

Post  hesh on Tue Jul 17, 2012 2:50 am

Thanks Ngalemmo for your valuable response


hesh

Posts : 12
Join date : 2011-08-16

View user profile

Back to top Go down

Re: Cube with two time dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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