MicroStrategy ONE

Creating a hierarchy prompt qualification

Before you begin

You should be familiar with filters (which contain at least one qualification), prompts, and custom groups. For background information, see About filters, Types of qualifications, About prompts, and About custom groups.

In a filter or custom group, a hierarchy prompt qualification allows the user to choose an attribute to qualify on at run time. The user is, however, restricted to choosing just the attributes from the selected hierarchy. After selecting the attribute, the user can qualify on ID or create an element list filter.

To create a hierarchy prompt qualification

 

  1. Choose one of the following:

    • To create a prompted filter, open the Filtering Options pane of the Filter Editor, if it is not already open. How?

    • To create a prompted custom group, open the Custom Group Options pane of the Custom Group Editor, if it is not already open. How?

  2. In the Object Browser, open the Hierarchies folder.

  3. Select the hierarchy to include in the report.

  4. From the Insert menu, choose Filter Prompt.

  5. The Choose from all attributes in a hierarchy filter definition containing the attributes that you selected is added to the Filter definition window.

    You can also create a hierarchy prompt on just a subset of the attributes in that hierarchy or a group of attributes. For example, the Time hierarchy has Year, Quarter, Month, Month of Year, and Date attributes. You want to create a hierarchy prompt that contains just Year, Quarter and Month attributes for users to choose from at run time. To create this prompt, select the attributes Year, Quarter, and Month and from the Insert menu choose Filter Prompt. You will see a message, "Do you want to prompt on a hierarchy subset created from the selected attributes?" Select Yes.

  6. Save the filter or custom group.