MicroStrategy ONE

Creating report filter qualifications on MDX cube reports

The workflow to create a report filter in an MDX cube report is slightly different than creating a report filter for a standard MicroStrategy report. Rather than creating a report filter qualification by selecting the type of qualification, in MDX cube reports you create report filter qualifications by selecting the fields, operators, and values for the qualification.

For information on how field, operator, and value components define a report filter qualification on MDX cube reports, see the MDX Cube Reporting Help.

Prerequisites

  • To create and modify an MDX cube report in MicroStrategy Developer, you need to have Developer privileges, including the Define MDX Cube Report privilege.

  • To create and modify an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report privilege.

  • At least one MDX cube must be imported into your MicroStrategy project. Importing MDX cubes is often handled by a MicroStrategy architect. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes in the MDX Cube Reporting Help.

To create a report filter qualification

  1. Open an MDX cube report for editing, or create a new MDX cube report, as described below:

    • To edit an MDX cube report, from MicroStrategy Developer, right-click an MDX cube report and select Edit. The Report Editor opens.

  2. Add attributes and metrics to the MDX cube report.

  3. If the Report Filter pane is not displayed, from the View menu, select Report Filter Definition. The Report Filter pane is displayed.

  4. In the Report Filter pane, click Click here to start a new qualification.

For information on how field, operator, and value components define a report filter qualification, see the MDX Cube Reporting Help. Be aware that the options you are prompted with to create a report filter qualification change depending on your choices for each successive component.

  1. Click Field, and then select the attribute or metric to qualify on.

    If the MDX cube report is connected to an SAP BW MDX cube with dimensions that contain multiple hierarchies, you may only be able to select from a subset of the attributes available in the MDX cube. This is because within a dimension, only one hierarchy can be represented on the report and report filter. For more information on this restriction, see the MDX Cube Reporting Help.

  2. Click Operator, and then select the operator for the qualification.

  3. Click Value, and then type a value, select attribute elements, or select a prompt that returns a value.

    If you need to import a text file for an attribute element qualification, note that the same rules apply to MDX cube reports as for standard reports. Namely, data in the file needs to be tab-delimited, return-delimited, or list-delimited as specified in the Regional Settings.

The report filter qualification is created.