Howdy!

I have got the following table for time dimension

TimeId Year Month Week
1 2004 1
2 2004 2
3 2004 3
4 2004 1
5 2004 2
6 2004 3

There is no day in the time dimension table.

I constructed a Dimension Hierarchy One from Year and Month Columns and
Called it Time.Month

I constructed another Dimension Hierarchy from Year and Week Columns and
Called it Time.Week

Both Time.Week and Time.Month are different hierarchies. And they do not
overlap.

Fact table has records for week and month(Each referred by their
respective time_id). Now during processing the Cube is expecting the
same TimeId which belongs to the month at the week-level also. Then
Bombs. How to resolve this ?

Mittche..

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

From your description, it appears that there are fact records with 2
different time grains: at the week and at the month level. In that case,
you can create 2 separate cubes for the 2 hierarchies (SQL views on the
fact table can filter the appropriate set of records for each cube).


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!