MicroStrategy ONE
Using MDX Cube Reports to Filter Other Reports
MDX cube reports can be used to filter other standard reports in MicroStrategy. This can be supported by using an MDX cube report as shortcut-to-a-report qualification on a standard report. For information on shortcut-to-a-report qualification, see the Advanced Reporting Help.
In Developer, with a standard report open, you choose Add a Shortcut to a Report to access the report as filter functionality.
The MDX cube report must map data to project attributes rather than managed object attributes. This is required for the standard report to recognize the data that is available on the MDX cube report. For information on mapping data in MDX cube reports to project attributes, see Mapping MDX Cube Data to Project Attributes.
You must have the Execute Multiple Source Report privilege, which is part of the MultiSource Option group of privileges. For information on MultiSource Option, see the Project Design Help.
To add an MDX cube report as a shortcut-to-a-report qualification in a standard report
- Open the standard report in Developer.
- In the Report Filter area, double-click the arrow to add a new qualification.
- Choose Filtering Options > Add a Shortcut to a Report.
- Click OK.
- Click the browse button (... ) to choose an MDX cube report.
- Click OK twice.