Prompts are the most versatile Application objects in MicroStrategy since they provide flexibility to customize the SQL sent to the database, based on a user response to a question that is presented before Report execution.
The following is a quick reference table for this MicroStrategy Object:
Basically, when a Prompt is inserted in an object, MicroStrategy placesa wildcard on the corresponding portion of the SQL. After this when the user responds to the Prompt, that unknown SQL gets replaced accordingly.
To better understand Prompts, it is necessary to explain the different types. Their type will determine what objects can be used to build them and how and where to use them.
- Filter definition prompt:
- What is it for? To dynamically create a Filter based on the user response
- What is made of? A Filter definition on a Hierarchy, Attribute, Metric, or by directly picking Attribute elements
- Where can it be used? Since it...