How to create N-Level deep nested prompts in Workstation

Introduction

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: 

Steps

• Create the highest level filter. This is a filter which contains a prompt on an attribute element list. 

• Click on Create Prompt as shown in the picture below, a new Embedded Prompt dialog will show up.

• Click Prompt for Elements of an attribute and add Year, you will see the dialog shown like this.

• 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.
• Similar to YEAR FILTER, create a filter on which contains a prompt on attribute element list of Quarter. Then click on All Elements

• Select Filtered elements and use 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, filter elements using the QUARTER FILTER created in 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.