Adding an Optional Prompt

To modify the simplified analytic query by adding an optional prompt:

  1. Search and open the required query from the Query Manager.

  2. Add a new prompt in the Prompt tab:

    • Add a new Field as a new prompt.

    • Select the Optional check box.

    • Search and select a Prompt table.

  3. Use the new prompt to update the criteria in the Criteria tab.

  4. Verify that the new prompt is added to the query using the Run tab.

  5. Open the base template in the pivot grid wizard from Reporting Tools, Pivot Grid, Pivot Grid Wizard. Navigate to Specify Data Model Values-Step 3 page. Enter appropriate value for the prompt in the Select Query Prompt Values section and save the base template.

  6. Create a new analytics report where you will find the new prompt listed. But existing analytic reports remain unchanged.

Note:

You can make the new prompt as a required prompt when you do not select the Optional check box and provide a default value to the prompt. In this case the existing reports will remain unchanged but when you create an analytic report using the same query, the new prompt is reflected.