Equal Elements under different hirarchies in one dimension

#1

Hi NG,

i have to create following dimension:

Cumulated_Month_Year
Single_Month
like

Cumulated_Month
Jan 02 cumulated
Jan 02
Feb 02 cumulated
Jan 02
Feb 02
Mrz 02 cumulated
Jan 02
Feb 02
Mrz 02
and so on

I've tried to create the dimension through a parent-child (2 connected
columns in one table)
It looks ok, BUT now there's my problem. How should i fill the fakt-table?
The values looks like (simple example):
Customer, Month, Value
In the dimension-table for the cumulated_month i got 10 different PKs for
the 'Feb 02'?!

Any suggests for another way to create the dimension or to fill the
fakt-table?

regards

Frank

#2

yongli wrote:

Quote:

The better approach will be to create a standard time dimension, then
create a cumulated_month_so_far measure, which should cover your
need.

Yes...in meantime i suggest the same
thx anyway

frank

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Equal Elements under different hirarchies in one dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Equal Elements under different hirarchies in one dimension - 07-14-2004 , 08:20 AM

Re: Equal Elements under different hirarchies in one dimension - 07-15-2004 , 10:14 AM