MicroStrategy ONE
Configuring how attribute element list qualifications are displayed
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. For more information on displaying other types, see Configuring the content of the filter details.
A filter can contain an attribute element list qualification, which qualifies on a list of attribute elements. For example, you can use an attribute element list qualification on the attribute Customer, in a report, to return data only for those customers that you specify in your list. For more information on attribute element list qualifications, see Attribute qualifications.
For these filters, you can configure how the lists are displayed using the following properties:
-
Show attribute name for In List conditions: Determines whether or not the name of the attribute in the filter's attribute element list is displayed. The name can also be repeated for each attribute element, for example, Region = Northeast, Region = Mid-Atlantic, where Region is the attribute name.
-
Separator after attribute name: Specifies the characters that separate the attribute name from the attribute element, typically an equals sign or colon (= :). To specify a separator, you must clear the Inherit check box before you can type in the Separator after attribute name field.
-
New line after attribute name: Determines whether or not the attribute name and its element display on separate lines.
-
Separator between last two elements: Specifies the text that separates the last two attribute elements in the list. The choices are:
-
or
-
and
-
comma (the character is used, not the text)
-
custom (in the Custom separator field, type the characters to use as the separator)
If you select custom, type a space following the characters in the Custom separator field, otherwise the last element is positioned immediately after the separator (andLast Element instead of and Last Element).
-
-
New line between elements: Determines whether or not each attribute element displays on a separate line. If each element is not displayed on a separate line, the attribute list wraps.
-
Trim elements: Specifies whether extra spaces in the attribute elements are deleted. For example, an account attribute has "PSI2415 : 10 :COMMERCIAL" as an element. If Trim Elements is enabled, the attribute is displayed as "PSI2415:10:COMMERCIAL".
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 properties, 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 are displayed.
-
If the report details preferences specify that the 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 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 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.