MicroStrategy ONE

How to Add a Stand-Alone Filter to a Report

A stand-alone filter is a filter created as an independent MicroStrategy object. Once a stand-alone filter has been created, you can add it to a report to filter the data displayed in the report. You can use stand-alone filters to simultaneously change the data displayed in multiple reports. To do so, add a stand-alone filter to each report, then make and save changes to the items selected in the filter. Each report that contains the filter is automatically updated to reflect your changes.

To compare stand-alone and embedded filters for reports, see Introduction to Filters.

DHTML must be enabled. See How to Enable DHTML in MicroStrategy Web.

To Add a Stand-Alone Filter to a Report

  1. Open the report you are creating a filter for. From the Home menu, select Design.
  2. If the Report Filter panel is not displayed above the report, display it by clicking the Filter icon Filter icon on the toolbar.
  3. From the left, select All Objects and navigate to the filter you want to add to the report.
  4. Right-click the filter and select Add to Report. If DHTML is disabled, select the filter and click Add > to add it to the Report Filter panel.

    If you added a prompted filter, the filter name is displayed when you first add the filter to the report. Once the report has been executed, and you return to edit the report, the filter's definition is displayed rather than the filter name.

  5. If other filter qualifications have been added to the report, you can determine the order that the qualifications are evaluated by clicking the Shift up icon next to a filter qualification.
  6. To run the report, click the Run Report icon Run Report icon.
  7. Save the report.

Related Topics

Introduction to Filters

Asking for User Input into a Filter Definition

Attribute Form Qualification

Attribute Element List Qualification

Metric Set Qualification

Shortcut-to-a-Report Qualification

Shortcut-to-a-Filter Qualification

How to Create a Filter within a Report: Embedded Filters