Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 01 Feb 2016 08:06:31 AM

Title: crosstab report studio report from 2 cubes.
Post by: cognos05 on 01 Feb 2016 08:06:31 AM
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
Title: Re: crosstab report studio report from 2 cubes.
Post by: Lynn on 01 Feb 2016 08:27:19 AM
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.
Text only | Text with Images