Adding a filter definition prompt or an object prompt containing filters to a filter

Before You Begin

A filter definition prompt qualifies on attribute elements and metrics in the qualification of a filter. An object prompt allows users to select which MicroStrategy objects to include in a report, and determine the definition of the report filter. This topic discusses adding a stand-alone prompt to a filter, although you can also create a prompt when you create a filter. For instructions to create an embedded prompt within a filter, see Prompted filters: Asking for user input for filter conditions.

You can add any of the filter definition prompts or an object prompt made up of filters to a filter in the Filter Definition pane of the Filter Editor. Then you add that filter containing the prompt(s) to a report. Use the steps below to add these prompt types to a filter.

Once your filter containing the prompt(s) is created, see Adding a filter to a report to add the filter to a report.

Prerequisites

This procedure assumes that the prompt has already been created.

To create a filter definition prompt, see About filter definition prompts.
To create an object prompt, see Filtering based on metrics, attributes, or other objects: Object prompts.

To add a prompt to the Filter Definition pane in the Filter Editor

Open the Filter Editor. In MicroStrategy Developer, use the Folder List on the left to navigate to the folder where you want to store your new filter. Then right-click on the right side of MicroStrategy Developer and select New, then select Filter. The Filter Editor opens.
Use the Object Browser on the left to locate the prompt that you want to add to the filter's definition.
- If the Object Browser is not displayed, from the View menu select Object Browser.
Drag and drop the prompt onto the Filter Definition pane.
Click Save and Close to save your filter and close the Filter Editor.

You can now add the prompted filter to any report, as described in Adding a filter to a report.

If you want to see what your report looks like when executed against the data source, and if you want to see how a prompt works for a user, once your report has one or more attributes and metrics in it, from the View menu select Grid View.