MicroStrategy ONE

Configuring How Attribute Element List Qualifications Are Displayed

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 the Basic Reporting Help.

For these filters, you can configure how the lists are displayed using the following settings. Examples are included below the list, on click here.

  • Show attribute name for In List conditions: Determines whether 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).

  • Separator after attribute name: Specifies the characters that separate the attribute name from the attribute element.

    In Developer, clear the Inherit check box to enable the Separator after attribute name field.

  • New line after attribute name: Determines whether 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)
  • New line between elements: Determines whether each attribute element displays on a separate line.
  • Trim elements: Determines whether extra spaces in the attribute elements are deleted. For example, an element of an account attribute is PSI2415 : 10 : COMMERCIAL. If Trim elements is enabled, the attribute is displayed as PSI2415:10:COMMERCIAL, omitting the extra spaces.

You can also choose to inherit the setting instead, as described in Levels of Report Details Configuration.

In the report sample below:

  • Show attribute name for In List conditions = Yes
  • New line after attribute name = Yes
  • Separator between last two elements = custom
  • Custom separator = , and (note that a space is included after the word "and")
  • New line between elements = No

In the following report sample:

  • Show attribute name for In List conditions = Repeated
  • New line after attribute name = No
  • Separator between last two elements = comma
  • New line between elements = Yes