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 his 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 MicroStrategy Basic Reporting Guide.
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.
DHTML must be enabled. See Enabling DHTML in MicroStrategy Web.
If you want analysts to answer a prompt by selecting from the results of a search object, a search object must already be created.
Do one of the following:
On the MicroStrategy Web home page, click Create Prompt. The Create Prompt page opens, with a list of the types of prompts that you can create. Click Attribute Qualification Prompt.
From any folder page, right-click, point to Prompt, and select Create 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 he creates to filter
data for the report.
On the Definition tab, choose one of the following options:
Choose an attribute: To specify the attribute a user can select elements from, browse to and select the attribute.
Use a predefined list of attributes: Select this option to create a list of attributes from which users can choose. Click Add, select the attributes, then click OK. To remove an object, highlight it and click Remove. To remove all items, click Clear.
Use the result of a search object: Select this option to browse to and select a previously created search object or specify the name of the 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 Guide.
From the Displayed forms drop-down list, select one of the following options:
All attribute forms: This option allows users to see and select from attribute elements within all attribute forms. It is the default choice.
Browse forms: This option allows users to see and select from only the attribute forms defined as 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 Desktop. For more information, see the MicroStrategy Project Design Guide.
Report display forms: This option lets users see only the attribute forms defined as report display forms. All attribute forms defined as report display forms are included in report results for a report that uses the related attribute.
Click the General tab.
Specify a title and description for the prompt in the Title and Instructions fields.
To restrict the number of prompt answers
To require users to answer the prompt before running the report, specify whether the prompt requires an answer. Select the Prompt answer is required check box.
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.
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 list, 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
Click the Style tab.
From the Display style drop-down list, specify a presentation style, such as Textbox, for the prompt. This is how the prompt is displayed to the user.
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 check boxes, and specify the size of the prompt's text fields and options in the fields.
To determine how prompt options are arranged, from the Orientation drop-down list, 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.
To determine whether to allow users to use a search box to locate prompt answers, from the Show search box drop-down list select FALSE or TRUE. Searching for objects allows analysts to quickly locate specific objects to use to answer the prompt.
If you are using the Shopping Cart display style, you can select the Use folder structure check box 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 check box.
To specify how qualifications are displayed in the prompt
Click the Qualification tab.
Determine the types of qualification expressions allowed in the prompt by selecting an option from the Expression type allowed drop-down list.
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 list.
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 list.
Determine how many elements are listed in each prompt answer list in the Maximum number of elements per list field.
To allow users to import a list of attribute elements from which they can choose, select the Allow element import check box.
To allow users to browse the elements in attribute qualification, select Allow element browsing in attribute qualification check box.
Determine the default logical operator that is used between conditions by selecting an option from the Default operator between conditions drop-down list.
To allow users to modify expressions, select the Allow modification of the logical operator check box.
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
To save the prompt, select Save As. The Save As dialog box opens.
Specify a name, description, and the location in which to save the prompt and click OK.
You can now add your new prompt to a report. See Adding a prompt to a report.