MicroStrategy ONE
Reports: Adding a prompt to a report, metric, filter, or custom group
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 the results are returned from your data source. Prompts are an effective way to design a single report that can support a broad user audience, since each user can designate the specific information that they want to see.
To get started creating a prompt, see About prompts.
You need to know what type of prompt you will be using when deciding where and how to add it to a report. You can add a prompt directly to a report, or indirectly by adding the prompt to a metric or filter. 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.
Use the following table when considering how and where to add a prompt to a report, metric, filter, or custom group:
Filter Type |
Add to Report Editor: Template Definition Pane |
Add to Report Editor: Report Filter Pane |
Add to Report Editor: Page-by Pane |
Add to Metric Editor: Definition Pane |
Add to Filter Editor: Filter Definition Pane |
Add to Custom Group Editor: Custom Group Definition Pane |
Filter Definition Prompts |
||||||
"Choose from all attributes in a hierarchy" prompt |
No |
Yes |
No |
No |
Yes |
Yes |
"Qualify on an attribute" prompt |
No |
Yes |
No |
No |
Yes |
Yes |
"Choose from an attribute element list" prompt |
No |
Yes |
No |
No |
Yes |
Yes |
"Qualify on a metric" prompt |
No |
Yes |
No |
No |
Yes |
Yes |
Object Prompts |
||||||
Object prompt of attributes |
Yes |
No |
Yes |
Yes |
Added as part of an advanced qualification or the level of a set qualification |
Added as part of an advanced qualification or the level of a set qualification |
Object prompt of metrics |
Yes |
No |
Yes |
Yes |
Added as part of a set qualification, and any place that accepts metrics |
Added as part of a set qualification, and any place that accepts metrics |
Object prompt of filters |
No |
Yes |
No |
Yes |
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 |
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, on an attribute form of a text data type |
Added as part of a set qualification, on an attribute form of a text data type |
Text prompt |
No |
No |
No |
No |
Added as part of an attribute form qualification, on an attribute form of a text data type |
Added as part of an attribute form qualification, on an attribute form of a text data type |
Level Prompts |
No |
No |
No |
Yes |
No |
No |
|
Add to Report Editor: Template Definition Pane |
Add to Report Editor: Report Filter Pane |
Add to Report Editor: Page-by Pane |
Add to Metric Editor: Definition Pane |
Add to Filter Editor: Filter Definition Pane |
Add to Custom Group Editor: Custom Group Definition Pane |
Where to find steps to add prompt to report |
Adding a prompt to the Template definition pane in the Report Editor |
Adding a prompt to the Report Filter pane in the Report Editor |
Adding a prompt to a metric's definition in the Metric Editor |
About adding a prompt to a filter's definition in the Filter Editor |