MicroStrategy ONE

Report Details Properties: Filter Details - Contents tab

The Filter Details - Contents tab of the Report Details Properties dialog box contains configuration options for the Filter Details, which displays information about filters on the report. This tab allows you to define the content of the Filter Details, by selecting which filter expressions to include (report filter, view filter, report limits, and so on) and how the filters are displayed. For example, you can select whether to include labels (that is, Report Filter, Report Limits, and so on) and the order in which the filter expressions are displayed.

The dialog box contains the following sections:

By default, each setting on this tab inherits the project setting, as described in Configuring report details. You can return to this default by selecting <default> from the drop-down list for the specific setting. The default setting is displayed, such as <default> (No).

Interaction of report details preferences and filter details

The report details preferences specified in the Developer Preferences dialog box overwrite some of the report details properties that deal with the content of the report details. These include 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 report details overview) 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.

General

Select whether to include or omit each of the following filter sub-expressions. You can also choose to inherit the setting instead.

  • Report Filter. If you select Yes, the following properties become available:

  • Report Filter Name: Choose whether to include it, omit it, inherit the setting, or automatic. If you select automatic, the report filter name is displayed for a stand-alone filter, but is omitted for an embedded filter.

  • Report Filter Description: Choose whether to include it, omit it, or inherit the setting.

  • Report Limits

  • View Filter. If you select Yes, the following property becomes available:

  • Metric Qualification in View Filter: Choose whether to include it, omit it, or inherit the setting.

  • Drill Filter. When a Grid/Graph is drilled on, this property determines whether or not the attribute element(s) drilled on are displayed in the report details of the drill report. If you drill from an attribute (as opposed to selecting elements), a drill filter is not created. For examples, see theReport Services Document Creation Guide.

  • Security Filter

Additional Options

You can configure how the filters are displayed in the Filter Details by specifying the following properties:

  • Include filter type name: defines whether to include the names of the filter types (that is, Report Filter, View Filter, and so on).

  • Show empty expressions: 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.

  • New line after filter type name: defines whether to add a new line after each filter type name, before the actual definition of the filter.

  • New line between filter types: defines whether to add a new line after each filter type to help differentiate between them.

  • Show report limits: defines whether to show the report limits before or after the view filter.

  • Expand shortcut filters: specifies 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

Related Topics