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
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