MicroStrategy ONE
Adding a Prompt to a Report
A prompt is a question the system presents to a user during report execution. How the user answers the question determines what data is displayed on the report when it is returned from your data source. For details on prompts in general and the various types of prompts, see Types of Prompts. You need to know what type of prompt you will be using when deciding where and how to add it to a report.
For example, Object prompts are most commonly placed directly on a report, but can also be placed in the condition part of a metric's definition in the Metric Editor, depending on the type of object in the Object prompt.
If you add a prompt to your report, you will be required to answer the prompt when you save the report. If you select Save report as prompted when you save the report, any subsequent times you open the report (in Editable or Presentation Mode), you will have to answer the prompt. Also, if you edit a prompted report and add another prompt to it, you will have to answer any prompts that you added during this session when you save the report. For more information about prompts, see About Prompts.
Use the following table when considering how and where to add a prompt to a report:
|
Prompt type |
Add To Report Editor: Template Definition Pane |
Add To Report Editor: Report Filter Pane |
Add To Report Editor: Page-by Area |
Add To Metric Editor: Definition Pane |
Add To Filter Editor: Filter Definition Pane |
|---|---|---|---|---|---|
|
Filter definition prompts |
|||||
|
Hierarchy prompt |
No |
Yes |
No |
No |
Yes |
|
Attribute prompt |
No |
Yes |
No |
No |
Yes |
|
Attribute Element prompt |
No |
Yes |
No |
No |
Yes |
|
Metric prompt |
No |
Yes |
No |
No |
Yes |
|
Object prompts |
|||||
|
Object prompt of attributes |
Yes |
No |
Yes |
Yes |
Added as part of an advanced qualification |
|
Object prompt of metrics |
Yes |
No |
Yes |
Yes |
Added as part of a set qualification, and any place that accepts metrics |
|
Object prompt of filters |
No |
Yes |
No |
Yes |
Yes |
|
Value prompts |
|||||
|
Date prompt |
No |
No |
No |
No |
Added as part of an attribute form qualification, on an attribute form of Date data type |
|
Numeric prompt, Long prompt, or Big Decimal prompt |
No |
No |
No |
Yes |
Added as part of a set qualification, as a metric value comparison |
|
Text prompt |
No |
No |
No |
No |
Added as part of an attribute form qualification, on an attribute form of a text data type |
Related Topics
Hierarchy Qualification Prompt
Attribute Qualification Prompt
How to Create a Metric Qualification Prompt