MicroStrategy ONE
Configuring the content of the filter details
Before you begin
This topic assumes that you are familiar with filters, especially the different types of filters and the components of filters. For background information, see Filters.
The filter details display the report filter and report limit of the report by default, although other types of filters can be displayed using the properties described below. You can:
-
Select which filter types to include. See Filter types for more details.
-
Select how the filters are displayed. See Filter display for more details.
Filter types
You can choose whether or not to include each type of filter. The filter types are listed below:
-
Report Filter
-
If the report filter is displayed, you can select whether or not to display the following:
-
-
Report Filter Name. You can also select another option, Automatic. If Automatic is chosen, the report filter name is displayed for a stand-alone filter, but is omitted for an embedded filter.
-
Report Filter Description
-
Report Limits
-
View Filter. If the view filter is displayed, you can select whether or not to display the following:
-
Metric Qualification in the View Filter
-
Drill Filter. When the document is drilled on, this property determines whether or not the attribute element(s) drilled on are displayed in the report details of the drilled-to report.The drill filter is the attribute
-
Security Filter
Filter display
You can select how the filters are displayed in the filter details by specifying the following properties:
-
Whether to include the names of the filter types (that is, Report Filter, View Filter, and so on).
An example with the names:
Report Filter (Local Filter): Year = 2026, 2027
Security Filter: Region=Northeast, Mid-Atlantic, Southeast
An example without the names:
(Local Filter): Year = 2026, 2027
Region = Northeast, Mid-Atlantic, Southeast
-
If the filter type name is included, specify whether to include empty expressions. An empty expression is a filter type that is not included on the report.
For example, a report contains a report filter and a security filter, but no report limits. If empty expressions are included, the results are:
Report Filter (Local Filter): Year = 2026, 2027
Report Limits: Empty Filter
Security Filter: Region=Northeast, Mid-Atlantic, Southeast
If empty expressions are omitted, the results are:
Report Filter (Local Filter): Year = 2026, 2027
Security Filter: Region=Northeast, Mid-Atlantic, Southeast -
Whether to add a new line after each filter type name, before the actual definition of the filter.
An example of new lines:
Report Filter (Local Filter):
Year = 2026, 2027
Security Filter: Region=Northeast, Mid-Atlantic, Southeast
An example with no new lines:
Report Filter (Local Filter): Year = 2026, 2027
Security Filter: Region=Northeast, Mid-Atlantic, Southeast -
Whether to add a new line between the different filter types to help differentiate between them.
An example of new lines:
Report Filter (Local Filter): Year = 2026, 2027
Security Filter: Region=Northeast, Mid-Atlantic, Southeast
An example with no new lines:
Report Filter (Local Filter): Year = 2026, 2027 Security Filter: Region=Northeast, Mid-Atlantic, Southeast
-
Whether to show the report limits before or after the view filter.
-
Whether to expand shortcut filters, which are stand-alone filters used in the report filter. The options are:
-
Show filter name
-
Show filter definition
-
Show name and definition
For example, Filter 1 is defined as Region = Northeast. A report contains the Year and Region attributes, as well as the Revenue metric. A local filter (that is, a filter defined in the Report Editor, not the Filter Editor) is created in the report, filtering on 2025. Filter 1 is added to the report filter. The examples below show how the filter details display for each of the shortcut filter options:
-
Show filter name: (Year = 2025) and {Filter 1}
-
Show filter definition: (Year = 2025) and (Region = Northeast)
-
Show name and definition: (Year = 2025) and ({Filter 1}:Region = Northeast)
By default, each of these settings inherits the project-level report detail definition set in the Project Configuration Editor, as described in Levels of report details configuration. You can return to this default by selecting <default> from the drop-down list.
For examples of these settings, see the Advanced Reporting Help.
Interaction of report details preferences and filter details
The report details preferences specified in the Developer Preferences dialog box specify which types of report details are displayed. These preferences override some of the report details that are configured in the Report Details Properties dialog box in the Project Configuration Editor and in the Report Editor. The report details preferences specify whether the filter details and view filter details are displayed, as well as whether the name or the definition is displayed for shortcut filters.
-
-
If the report details preferences specify that the filter or view filter details are not displayed, you cannot display them using the Report Details Properties dialog box.
-
If the report details preferences specify that the filter or view filter details are displayed, you cannot hide them using the Report Details Properties dialog box. You can use the Report Details Properties dialog box to configure how they are displayed, however.
-
You cannot change whether the filter name or filter definition are shown.
You can change this behavior by disabling the report details preferences, allowing the report details properties to be used instead. You can disable the report details preferences when you save changes to the report details properties (as described in Configuring the content of the filter details) or by using the Developer Preferences dialog box (for instructions, see Disabling report details preferences). For more information about the report details preferences in general, and how to set them, see Enabling and customizing report details preferences.