Print Page - Creating a single cross tab report based on 2 cubes

Title: Creating a single cross tab report based on 2 cubes
Post by: cognos05 on 15 Feb 2016 10:05:51 AM

I have 2 cubes one with Sales for X product category and other cube with Sales with Y product Category.

Crosstab 1

Sales Product X
Customers

CorssTab2
Sales Product Y
Customers

I just need one craoostab report,
Sales on ProductX Sales on Product Y
Customers

How do I achieve this in single crosstab report.

Thanks,
Nithya

Title: Re: Creating a single cross tab report based on 2 cubes
Post by: MFGF on 15 Feb 2016 12:09:37 PM

Quote from: nithya1224 on 15 Feb 2016 10:05:51 AM
I have 2 cubes one with Sales for X product category and other cube with Sales with Y product Category.

Crosstab 1

Sales Product X
Customers

CorssTab2
Sales Product Y
Customers

I just need one craoostab report,
Sales on ProductX Sales on Product Y
Customers

How do I achieve this in single crosstab report.

Thanks,
Nithya

Hi,

You're going to need a single cube that contains all the required data here.

MF.

Title: Re: Creating a single cross tab report based on 2 cubes
Post by: cognos05 on 15 Feb 2016 01:21:54 PM

What if I dont show the products in column and instead show total prod X and total prod Y. Customers are still same right ?

Thanks,
Nithya

Title: Re: Creating a single cross tab report based on 2 cubes
Post by: MFGF on 16 Feb 2016 03:22:40 AM

Quote from: nithya1224 on 15 Feb 2016 01:21:54 PM
What if I dont show the products in column and instead show total prod X and total prod Y. Customers are still same right ?

Thanks,
Nithya

Hi,

Although they might have the same captions, the customer members in each cube will have different Member Unique Names (MUNs), so they are not the same under the covers.

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 15 Feb 2016 10:05:51 AM