Configuring the Content of the Filter Details

You can choose whether to include each type of filter. The filter types are listed below:

• Report Filter

  If the report filter is displayed, you can select whether 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 to display the following:

  • Metric Qualification in the View Filter
• Drill Filter

  When the report is drilled on, determines whether the attribute element(s) drilled on are displayed in the report details of the drill report. For examples, see Drill Filter: Examples.

• Security Filter

  For each option, you can also choose to inherit the setting instead, as described in Levels of Report Details Configuration.

  Steps to configure the filter details are provided in the MicroStrategy Developer help.

Filter Types: Examples

The following report displays some of the different filter types.

The report filter is embedded, and the Report Filter Name option is set to Automatic, therefore no name is displayed for the report filter. If the Report Filter Name option was set to Yes instead, the report details would display as:

Report Filter (Local Filter)

Category = Books, Movies

If the report filter was a stand-alone filter (not a filter embedded in that report), the name displays if the Report Filter Name setting is set to Automatic or Yes. For example, if the report was filtered by the stand-alone filter named Southern Regions, the report details display as:

Report Filter (Southern Regions)

Region = South, Southeast, Southwest

The Content of the Filter Types: Examples

You can configure how the filters are displayed in the filter details by specifying the following settings:

• Whether to include the names of the filter types, such as Report Filter, View Filter, and so on.

  In the report sample above, the names are displayed. If the names are omitted, the filter details display as:

  (Local Filter): Category=Books, Movies

  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, the report sample above lists report limits and view filter, even though the report does not contain either one. The filter details could instead display only those filter types that the report contains, such as:

  Report Filter (Local Filter):

  Category = Books, Movies

  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.

  For example, the report sample above includes a new line after each filter type name. If the line is omitted, the filter details display as:

  Report Filter (Local Filter): Category= Books, Movies

  Security Filter: Region=Northeast, Mid-Atlantic, Southeast

• Whether to add a new line between the different filter types to help differentiate between them.

  For example, the report sample above includes the new line. If the line is omitted, the results are:

  Report Filter (Local Filter): Category= Books, Movies Security Filter: Region= Northeast, Mid-Atlantic, Southeast

  The report sample above does not have a new line between the filter types or after the filter type name.

• 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

In all cases, the definition of embedded filters is displayed. (An embedded, or local filter, does not have a name.)

For example, Filter 1 is defined as Region = Northeast. A report contains the Category and Region attributes, as well as the Revenue metric. A local filter (also called an embedded filter) is created in the report, filtering on Books. Filter 1 is added to the report filter. If the filter name (Filter 1 in this case) is shown, the filter details look like the following:

Report Filter:

(Category = Books) And {Filter 1}

If the filter definition (Region = Northeast in this case) is shown, the filter details look like the following:

Report Filter:

(Category = Books) And (Region = Northeast)

If both are shown, the filter details look like the following:

Report Filter:

(Category = Books) And ({Filter 1}: Region= Northeast)

Drill Filter: Examples

The drill filter is the attribute element(s) that you selected when you drilled on the report. The drill filter is displayed in the drilled-to report.

For example, a report contains the Category and Region attributes, as well as the Revenue and Profit metrics. A portion of the report is shown below. Notice that the Report Details pane is blank—although filter details have been included, the only kind of filter that is displayed is the drill filter. Since this report is not a drill report, nothing is displayed.

Drill on the report from Books/Central down to Call Center, as shown above. Now the Report Details pane displays the drill filter information, that Books and Central were selected when the drill was performed.

If the drill filter was turned off, the Report Details pane would be blank in the drill report.

If you drill from an attribute (as opposed to selecting elements), a drill filter is not created. The report is not filtered; it is just displayed at a different level. For instance, select the Region attribute instead of the Central region (an element of the Region attribute) in the original report, as shown below.

The resulting drill report is displayed below. The report is the same as the original, but at the Call Center level rather than Region. All regions and all categories are still displayed, unlike the first drill report that was filtered for Books and Central. In other words, the report is not filtered, so the drill filter details are not displayed and the Report Details pane remains blank, because a drill filter was not created.