Cube with two time dimensions

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

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.

Thanks Ngalemmo for your valuable response