Global Filters and Reports using different cubes

[kgcognos]

Due to performance issues, we had split our Sales cubes by Company.

My requirement is to create a Page showing the products sales by company .
So I have 5 Product Sales RS reports. Each is using a company cube.
I added the 5 reports in a Page.

I need users to filter the reports by product. I have 1 separate prompt page that I was hoping would be passed to these reports.
But it is failing since the name of the cube is different [mun is different]

Is it possible to have a global filter and pass it to reports using different cubes?
Please advice. Thank you
     

[schrotty]

Hi,

The MUN is unique per cube and contains the cube-name?

1) Use the dimensional filter function to filter your products (i.e. by product name or number) per Cube

Or

2) Use the macro functions to generate a Product MUN per Cube

schrotty