N-Level deep nested prompts in MicroStrategy
Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. This feature is only implemented for element list prompts. The following procedure describes how to achieve this:
- Create the highest level filter. This is a filter which contains a prompt on an attribute element list. Create a filter on the attribute "Year." Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Do not set any additional conditions. Save the filter as "YEAR FILTER:"
From this level on, each filter will contain both a prompt on an element list and will have its element list filtered by the filter created one level above it. There is no limit to the number of such filters that can be layered. - Create a filter on attribute "Quarter" and click "Prompt." Select "Use a filter to reduce the number of elements" and select the "YEAR FILTER" created in the previous step:
- Save this filter as "QUARTER FILTER:"
- Follow the same basic procedure as above to create a Month filter. Create a filter on attribute "Month" and click "Prompt." Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step.
- Place only the lowest level filter in the filter section of the report. In this case, the "MONTH FILTER" will be placed in the filter section:
When the report is executed, it will prompt for year, then for quarters in the selected year, then for months in the selected quarter, as shown in the following sequence of screenshots:
Comments
Post a Comment