Attribute Qualification Prompt

The Attribute prompt can be used to create a more focused prompt than the Hierarchy prompt. You determine a single attribute from which each user who executes the report can select elements to define their report filter. You can also let users select an attribute from a set of attributes, and then select elements from their chosen attribute.

For an example and images of an Attribute prompt, see the Answering Questions about Data chapter in the Basic Reporting Help.

Of the three filter definition prompts for attributes, the Attribute prompt is more restrictive than a Hierarchy prompt but less restrictive than an Attribute Element prompt. 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 element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria.

You can create a stand-alone prompt, or you can create a prompt that is embedded in a filter. An Attribute Qualification prompt can be used in an Attribute form qualification.

DHTML must be enabled. See How to Enable DHTML in MicroStrategy Web.

To create an Attribute Qualification prompt

Click Create > New Prompt > Attribute Qualification Prompt.

To select the attribute from which the user creates the filter

You must determine which attribute is displayed to the user in the prompt. (Alternatively, you can present the users with a list of attributes and the user selects one attribute from the list.) The user then selects elements from that attribute to be part of the filter they create to filter data for the report.

Open the Definition tab.

• To specify the attribute a user can select elements from, select Choose an attribute. Browse to and select the attribute.
• To create a list of attributes from which users can choose, select Use a predefined list of attributes. Click Add then click OK. To remove an object, highlight it and click Remove. To remove all items, click Clear.
• To browse to and select a previously created search object or specify the name of the search object, select Use the result of a search object. A search object searches for and displays specific project objects when the user executes the report. This lets you prompt the user with the most up-to-date objects in the project. Use this option to present the user with a list of attributes, from which they can choose one.

To determine which attribute forms to display to the user

The prompt displays the related attribute elements for users to select their filter criteria from. The attribute's forms can also be displayed. For more information about attribute forms, see the Advanced Reporting Help.

1. From the Displayed forms drop-down, select one of the following options:

   • To allow users to see and select from attribute elements within all attribute forms, select All attribute forms. This is the default choice.
   • To allow users to see and select from only the attribute forms defined as browse forms, select Browse forms. All attribute forms defined as browse forms are displayed in the Data Explorer when the user browses the related attribute. Browse forms are specified in MicroStrategy Developer. For more information, see the Project Design Help.
   • To let users see only the attribute forms defined as report display forms, see Report display forms. All attribute forms defined as report display forms are included in report results for a report that uses the related attribute.
   • To specify a customized set of attribute forms to display to users, select Custom display forms. In the list of attribute forms in the bottom left, select the attribute forms that you want to display, then click the Add icon to add the attribute forms to the list on the right. You can select more than one attribute form at the same time by pressing CTRL and clicking additional attribute forms. This option is available only if the Choose an attribute option is selected.
2. Click the General tab.
3. Specify a title and description for the prompt in the Title and Instructions fields.

To restrict the number of prompt answers

1. To require users to answer the prompt before running the report, specify whether the prompt requires an answer. Select the Prompt answer is required checkbox.
2. Set the maximum and minimum number of prompt answers allowed, if you choose. Enter these numbers in the Minimum number of answers and Maximum number of answers fields. You can specify a minimum number even if you do not specify a maximum number.

3. Determine whether users can save and reuse their prompt answers, and if so, how many prompt answers they can save for the prompt. From the Personal answers allowed drop-down, select one of the following:

   • None: Users cannot save and reuse prompt answers.
   • Single: Users can save and reuse only one prompt answer.
   • Multiple:Users can save and reuse multiple prompt answers.

To specify the layout and display style of the prompt

1. Click the Style tab.
2. From the Display style drop-down, specify a presentation style, such as Textbox, for the prompt. This is how the prompt is displayed to the user.
3. To ensure that the prompt's text fields and options are a fixed size, select the Fixed text box width and/or Fixed textbox height checkboxes, and specify the size of the prompt's text fields and options in the fields.

4. To determine how prompt options are arranged, from the Orientation drop-down, select Vertical or Horizontal.

   To determine the number of prompt answers displayed in a row or column (depending on alignment), enter a number in the Items per column/row field.

5. If you are using a search object, you can determine whether to allow users to use a search box to locate prompt answers. Searching for objects allows analysts to quickly locate specific objects to use to answer the prompt. From the Show search box drop-down, select one of the following options:

   • To display the search box, select TRUE.
   • To not display a search box, select FALSE.

   The Show search box option is not available if you are using the Textbox display style.

6. If you are using the Shopping Cart display style, you can select the Use folder structure checkbox to display the prompt choices in a folder structure. This option, available for search objects only, is useful when the same object with the same name is saved in multiple folders.

   • To allow users to navigate above the root folder when searching, select the Allow navigation above search root checkbox.

To specify how qualifications are displayed in the prompt

1. Click the Qualification tab.
2. Determine the types of qualification expressions allowed in the prompt by selecting an option from the Expression type allowed drop-down.
3. Determine the default condition (for example, Select or Qualify) that is displayed in the prompt by selecting an option from the Default expression type drop-down.
4. Determine the default condition operator (for example, Greater than or Less than) that is displayed in the prompt by selecting an option from the Default condition operator drop-down.
5. Determine how many elements are listed in each prompt answer list in the Maximum number of elements per list field.
6. To allow users to import a list of attribute elements from which they can choose, select the Allow element import checkbox.
7. To allow users to browse the elements in attribute qualification, select Allow element browsing in attribute qualification checkbox.
8. Determine the default logical operator that is used between conditions by selecting an option from the Default operator between conditions drop-down.

9. To allow users to modify expressions, select the Allow modification of the logical operator checkbox.

   • To ensure that users can only use a single condition operator (AND/OR) between all of the conditions in an expression, select the Use a single logical operator between all conditions option.
   • To ensure that users can choose a default operator to use between each condition, select the Allow the user to set independent logical operators between conditions option.

To save the prompt

If you creating a prompt for a filter, click OK .To finish creating the attribute form qualification, begin at this step.

1. Click Save As.
2. Click OK.

You can now add your new prompt to a report. See Adding a Prompt to a Report.