MicroStrategy ONE

"Choose from all attributes in a hierarchy" prompts (Hierarchy prompts)

Before You Begin

This topic assumes that you are familiar with the concepts in About prompts and About filter definition prompts.

A "Choose from all attributes in a hierarchy" prompt, also called a Hierarchy prompt, allows users to create their own report filter using attributes and attribute elements from:

  • A specific hierarchy

  • All hierarchies in the project

  • A set of hierarchies returned by a search object

For example, analysts want to be able to monitor the aging of various accounts receivable transactions by customer. You create a report with the Customer attribute and various Accounts Receivable-related metrics on it. (The report and its metrics are shown below.) You want users to be able to select any corporations or parent corporations to view past-due amounts for, when they execute the report.

You create a hierarchy prompt which asks the user to choose an attribute or attribute elements from the Organization hierarchy. Then you add the hierarchy prompt to the report.

Using the MicroStrategy Financial Reporting Analysis Module project data, when you execute the report and respond to the prompt by choosing the Global Enterprises HQ corporation, the report appears as shown in the following image. (This image shows only part of the resulting report.)

Report with Customer attribute and receivables metrics

Of the three filter definition prompts for attributes, the Hierarchy prompt allows users to select from the widest number of attribute elements when they are choosing prompt answers to define their filtering criteria. The Attribute prompt is more restrictive, and the Attribute Element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria.

Use Hierarchy prompts in the qualifications of filters and custom group elements. For a table of where to use all prompts, see Adding a prompt to a report, metric, filter, or custom group.

Prerequisites

Before you create this type of prompt, you should:

  • Know the hierarchies that you want the user to choose from.

  • Know how the attribute forms within those hierarchies are displayed in reports. Use the attribute display properties to determine how the forms are displayed.

  • Create a search object, if you want to use the results of a search in the prompt. You can also create it while creating the prompt.

To create a "Choose from all attributes in a hierarchy" prompt

If you are in the process of creating a prompted attribute qualification, begin at step 4 of this procedure. This step places you at the correct page when the wizard is accessed from the Filter Editor to create a prompted attribute qualification.

  1. Open the Prompt Generation Wizard. How?

  2. On the Welcome page, choose Filter definition prompt, then select Choose from all attributes in a hierarchy.

  3. Click Next. The "Choose from all attributes in a hierarchy" page opens.

  4. Select the hierarchy which contains the attributes that the user will be prompted to choose from as he creates the filter for the report.

  5. Select the hierarchies to display in the prompt by doing one of the following:

    • To display all hierarchies in the project, select List all hierarchies (no restrictions).

    • To display a specific hierarchy, select Choose a hierarchy object. Enter the name of the hierarchy, or click ... (the browse button) to display the hierarchies in the project.

    • To display a set of hierarchies from a search object, select Use the results of a search object. A search object searches for and displays specific project objects when the user executes the report. This allows you to prompt the user with the most up-to-date objects in the project. Do one of the following:

    • To use an existing search, click ... (the browse button). Navigate to the search object, select it, and click OK to return to the Prompt Generation Wizard.

    • To create a new search, click New. The Search for Objects dialog box opens. Enter your search criteria and save the search. Then browse to and select your new search object or specify the name of the search object. (For more detailed instructions to create a new search object, see Search for Objects dialog box.)

    • To allow the user to choose attributes from a list of hierarchies that you specify, select Use a predefined list of hierarchies. Create the list using the buttons described below:

    • To choose the hierarchies for the list, clickAdd, which opens theSelect Objects dialog box. Select the hierarchies, then click OK to return to the Prompt Generation Wizard.

      Once a hierarchy has been selected, the Add button is replaced by the Modify button.

    • To modify the list, click Modify,which opens theSelect Objects dialog box. Add or remove hierarchies, then click OK to return to the Prompt Generation Wizard.

    • To delete a hierarchy from the list, select the hierarchy and click Remove.

    • To remove all the hierarchies from the list, click Clear.

    • To change the order that the objects are displayed in the prompt, select a hierarchy and click theUp and Down arrows to move the selected hierarchy.

    • To determine the attribute forms which are displayed to the user

    • Once users select a hierarchy, the prompt displays the related attributes and attribute elements for users to select their filter criteria from. The attribute forms can also be displayed.

    • An attribute form is a descriptive aspect of an attribute. Most attributes have at least two forms, ID and description (Desc). For example, the Product attribute has an attribute form called ID, which is made up of ID numbers that represent each attribute element (each product). The attribute form Last Name contains the last names for each attribute element, such as each customer in the Customer attribute, or each employee in the Employee attribute. Your project designer determines which attribute forms users see directly in a report's results (the report display forms), and which attribute forms users can see displayed in the Object Browser, for browsing purposes (the browse forms). You can choose which of these display types users can select from when they answer the prompt.

  6. Select how to display the attribute forms, by choosing an option from the Displayed forms drop-down list:

    • All attribute forms (the default) displays all attribute forms.

    • Browse forms displays only the browse forms defined in the Display tab of the Attribute Editor.

    • Report Display forms displays only the report display forms defined in the Display tab of the Attribute Editor.

      The actual number of attribute forms displayed during prompt resolution depends on the attribute definition and on how the project architect categorized the attribute forms. Use the attribute display properties to determine how the forms are displayed.

  7. Click Next. The General Information page opens.

    For considerations when determining a title and description, see Title and instructions.

  8. Type a Title, which is used as the default object name when you save the prompt, although you can change it. The title is also displayed to users when the prompt is run during report execution.

    To display a blank title, type a space in the Title field. If you leave Title blank, a default name, such as Region for an attribute prompt on Region, is displayed when the prompt is run.

  9. Type text in the Instructions field, which is displayed when the prompt is run during report execution.

    • To display blank instructions, type a space in the Instructions field. If you leave Instructions blank, default instructions, such as Qualify on Region for an attribute prompt on Region, are displayed when the prompt is run.

  10. To determine how the prompt appears when it is executed in MicroStrategy Web, click Modify. The Web Options dialog box opens. This dialog box displays options for prompt style and style properties. You can also configure how the user can define the attribute qualification in the prompt when the prompt is executed in MicroStrategy Web. For instructions, see Defining how a prompt is displayed in MicroStrategy Web.

    • To allow personal answers

    • Personal answers allow a user to save prompt answers for this prompt, and then reuse the answers on any report that this prompt is used on. For a more detailed description of personal answers and how they can be used, see Allowing personal answers for prompts.

  11. To determine whether personal answers can be saved for this prompt, select one of the following options from the Personal answers allowed drop-down list:

    • None: No personal answers can be saved. Every time a user sees the prompt, he must answer it manually (if it is required) or ignore it.

    • One: Only one personal answer can be saved for this prompt. When the prompt is used again (on this report or a different one), the personal answer is displayed. A user can keep the personal answer, or add or delete selections. He can save his changes as a new personal answer, but only one personal answer can be saved for the prompt.

    • Multiple: Multiple personal answers can be named and saved, allowing different answers for the same prompt. When the prompt is used again (on this report or a different one), the personal answers are available. The user can select one of them, or answer the prompt manually.

    • To define prompt restrictions

  12. In the Max number of elements per selection field (optional), enter the maximum number of elements that a user can select when answering the prompt.

  13. To require a minimum number of qualifications, select the Minimum number of qualifications check box. Enter the minimum.

  14. To restrict the number of allowed qualifications, select the Maximum number of qualifications check box. Enter the maximum.

  15. To require that the user answer the prompt at run time, select the Promptanswersrequired check box.

    If you select Prompt answer required without providing default answers, the report cannot execute on a schedule. For information on how required prompt answers, default answers, and schedules interact, see Prompts in scheduled reports.

  16. Click Next. The Default Prompt Qualification Selection page opens.

    • To specify a default answer

    • A default answer can allow users to complete report execution more quickly, since they do not need to answer the prompt but can simply run the report using the default answer. The user can select the default, or create his own qualification. For considerations when determining a default answer, see Default prompt answers. You do not need to specify a default answer if you do not want a default answer to appear for users.

  17. If you do not want to define default qualifications, click Finish. The Save As dialog box opens.

  18. To define default qualifications:

    1. To create the qualification, click Add. Create a filter using theQualification Editor that opens. When you save the filter, you are returned to the Prompt Generation Wizard. The qualification is displayed in the table. To delete all the default qualifications, click Clear.

      Once you add a default, the Add button is renamed Modify. Click it to modify the qualification or add additional qualifications.

    2. Click Finish. The Save As dialog box opens.

    • To save your prompt

  19. Select the folder in which to save the new prompt, enter a name, and click Save to return to MicroStrategy Developer.

    If you are creating a prompted attribute qualification, you are returned to the Filter Editor after you click Finish. You do not save the prompt as a separate object. Return to that procedure, beginning at this step.

You can now add your new prompt directly to a report (in the report filter), or indirectly by adding the prompt to a filter or custom group. For instructions, see:

For a table showing how to add each prompt type to objects, see Reports: Adding a prompt to a report, metric, filter, or custom group.

Related Topics