Hi all,
I'm new to CX and I have a report with 2 charts linked to 2 different cubes with some shared dimensions. I can easily drill down and up in either of these charts but would like both charts to drill up or down simultaneously. I've tried to use Data Items Linking tab but that returns an error when running the report since it is using the [cube].[dimension].[element] convention with 2 different cubes.
I'm thinking it should be possible to do this but have run out of ideas.
Can anybody help me?
Thanks
George
CX Report Studio - 2 cubes
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: CX Report Studio - 2 cubes
Which version of CX? In the latest release you can do this in an Advisor canvass by setting up a common "channel" for the offspread dimensions in the views. Fairly easy to integrate a Advisor or Xcelerator web frame into Reporter.
I know this isn't exactly what you're trying to do but its another solution should you run out of options. Although I think what you are trying to do must be possible or at least it SHOULD be possible, but I like you don't know how to do it offhand.
I know this isn't exactly what you're trying to do but its another solution should you run out of options. Although I think what you are trying to do must be possible or at least it SHOULD be possible, but I like you don't know how to do it offhand.