MicroStrategy ONE

Creating a shortcut-to-a-report qualification

You can use the result set of an existing report as a report filter in another report. Often the result set of one report may be needed as a report filter in another report. Instead of creating a new report that includes the results of the first report, you can use the first report itself as a filter inside the new report. When you use the first report as a filter, only the report's data definition is considered; any changes to the view definitions do not influence the filter conditions.

This type of qualification is also known as a report as filter qualification or a report qualification.

You cannot use a report containing consolidations, a report with custom groups, a Freeform SQL report, or an MDX cube report as a shortcut to a report.

You can also create a report object prompt and use it in a report. For more information refer to Report object prompts (shortcut to a report).

For more information and examples of report qualifications, see the Creating a Query chapter of the Basic Reporting Help.

To create a shortcut-to-a-report qualification

  1. Open the Filtering Options pane of the Filter Editor, if it is not already open. How?

  2. Select Add a Shortcut to a Report and click OK. The Shortcut to a Report pane opens.

  3. Do one of the following to select the report:

    • Type the name of the report in the Report box and click OK.

    • Click ... (the browse button) to browse for the report. In the Open dialog box, navigate to the folder that contains the report, select the report, and click OK.

    • Drag the report from the Object Browser into the Report box.

      You cannot use a report containing consolidations, a report with custom groups, a Freeform SQL report, or an MDX cube report as a shortcut to a report.

  4. Click OK to close the Shortcut to a Report pane.

  5. Do one of the following:

    • Add more qualifications to the filter. Double-click in the Filter definition pane to open the Filtering Options pane again. These can be attribute qualifications or other types of qualifications.

      If you have multiple qualifications, you can change the operator connecting them. To do this, right-click the operator in the Filter definition pane, point to Toggle operator, then select the new operator from the list.

    • Save the filter. How?

Related Topics