Merging date dimensions

#1

Hi,

I have 2 cubes which I will merge to 1 virtual cube.
The first one is the forecasted sales (with a date ofcourse) and the
second is the booked sales (with a date).
In the new virtual cube I would like to merge the two date dimensions.
Or in other words I just want 1 date dimension in the new virual cube.

Please can you tell me how?

Thanks a lot

#2

You can hide one of the dims, then use the LinkMember function to integrate.

tom @ the domain below
www.tomchester.net

"Pierre" <hayobaas (AT) planet (DOT) nl> wrote

Quote:

Hi,

I have 2 cubes which I will merge to 1 virtual cube.
The first one is the forecasted sales (with a date ofcourse) and the
second is the booked sales (with a date).
In the new virtual cube I would like to merge the two date dimensions.
Or in other words I just want 1 date dimension in the new virual cube.

Please can you tell me how?

Thanks a lot

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

Merging date dimensions

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

Merging date dimensions - 09-10-2003 , 03:56 AM

Re: Merging date dimensions - 09-10-2003 , 10:10 AM