Creating a single cross tab report based on 2 cubes

[cognos05]

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

[MFGF]

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.

[cognos05]

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

[MFGF]

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.