Object prompts

Object prompts provide users the ability to add additional objects to a report. You can let users select from almost any object available in MicroStrategy. The objects the user selects in the prompt are placed on the report. This essentially allows users to create their own reports, although you use the object prompt to control what objects they can choose to include on their reports.

For example, you can create a prompt that allows users to choose from a list of existing stand-alone filters to apply to the report. Or, you can create a prompt that displays the Day, Month, Quarter, and Year attributes to users, so the user can specify the granularity of the report. Object prompts enable you to provide versatile reports to users.

Additional examples and images of an object prompt can be found in the Answering Questions about Data chapter in the Reporting Guide.

Object prompts can be used in many places, including the following:

When you create an object prompt, you can decide whether users can select from a specified list of MicroStrategy objects, or you can define a specific search that presents an up-to-date set of objects for users to select from. Including a search object in the object prompt, rather than specifying the exact object names, allows users to select from new objects that might not have been part of the project when you first created the prompt.

Prerequisites

To create an object prompt

  1. Do one of the following:

  2. Choose one of the following options:

  3. On the General tab, specify a title and description for the prompt in the Title and Instructions fields.

  4. 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. If you require an answer, it is a good idea to also provide a default answer, otherwise a subscription to this report will fail.

  5. Set the maximum and/or minimum number of prompt answers allowed, if desired. Enter these numbers in the Minimum number of answers and Maximum number of answers fields.

  6. 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:

  7. On the Style tab, from the Display style drop-down list, specify a presentation style, such as Check box, for the prompt. This is how the prompt is displayed to the user.

  8. To ensure that the prompt's text fields and options are a fixed size, select the Fixed textbox width and/or Fixed textbox height check boxes, and specify the size of the prompt's text fields and options in the fields.

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

  10. 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.

  11. 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. Use the up and down ordering arrows to reorder prompt objects.

  12. For an object prompt that uses a search object and the Tree display style, the Use folder structure check box is selected and cannot be changed. You can select whether or not empty folders are shown in the tree when the prompt is executed. Select or clear the Do not show empty folders check box. Note that selecting it can impact performance.

    Note
    : The search object must search within subfolders. For background information on search objects and steps to create them, see the Desktop Help.

  13. To save the prompt, select Save As. The Save As dialog box opens.

  14. 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.