MicroStrategy ONE

Filter Editor toolbar options

The Filter Editor provides a set of toolbar icons to facilitate the tasks of filter definition and modification. In addition to standard Windows options such as print, these icons include the following filter-specific options:

  • Add to Filter: adds the object selected in the Object Browser to a filter definition.

  • Filter Prompt: creates a prompted filter from the object selected in the Object Browser.

  • If the selected object is an attribute, the Prompt Generation Editor opens to create a prompted attribute qualification, which allows a user to choose the attribute elements, attribute forms, or operators on which to qualify at report run time.

  • If the selected object is a hierarchy, metric, report, or filter, a hierarchy prompt qualification, a prompted metric qualification, a report object prompt, or a filter object prompt, respectively, is added as a qualification.

  • Increase Indent: indents the selected operator and its associated qualifications to the right. Qualifications in a filter that are grouped and indented to the same level are evaluated together.

    • For example, two qualifications are connected through the AND operator. If you select the AND operator and increase the indent, the two qualifications along with the operator move to the right.

  • Decrease Indent: indents the selected operator and its associated qualifications to the left. Qualifications in a filter that are grouped and indented to the same level are evaluated together.

    • For example, two qualifications are connected through the AND operator. If you select the AND operator and decrease the indent, the two qualifications along with the operator move to the left.

  • Move Up: moves the selected qualification one level up in the definition. Qualifications in a filter are evaluated in the order in which they appear, with the qualifications at the top of the filter being evaluated first. For an example, see Changing the evaluation order of qualifications in a filter.

  • Move Down: moves the selected qualification one level down in the definition. Qualifications in a filter are evaluated in the order in which they appear, with the qualifications at the top of the filter being evaluated first. For an example, see Changing the evaluation order of qualifications in a filter.