crosstab report studio report from 2 cubes.

[cognos05]

Hi,

I have a daily sales cube which has only days from 1 to 31 and rest all dimensions are same.
I have a ytd sales cube and which has time dim with YTD and rest all dimensions are same.

I need to create a crosstab report as shown below
  Measure             CurrentDay Sales            YTD SALES                 

                            Products                         Producs
Customers       

A001                      100                               15000



I can create two cross tabs with current day and ytd sales data seperately

I know I have create a master detail link with caption of customers .
But I am stuck at this point on how to proceed. Put a list ? bring one crosstab inside other ?


Any suggestions is appreciated.

Thanks,
Nithya

[Lynn]

Wouldn't YTD sales actually be YTD including the current period? If not then it isn't really "to date".

I'm not sure the approach you are taking is the best choice.