Identical Prompts and Variables

When a variable exists and the data source has multiple references, or when the same prompt exists in multiple grids, the Respond to Prompts dialog box shows a list where users choose whether they want to respond to prompts at the Grid, Report/Book or Batch level. The selections shown in the drop-down list depend on whether the Respond to Prompts dialog box is shown while running a Report, or Book or from within the Batch editor. The drop-down list is displayed only when a selection is needed. Similarly, if a Report, Book or Batch contains only a single Prompt, or the Prompts are different (different dimensions, default members, or choices list), the drop-down selection is not displayed.

Selections when running a Report:

Selections when running a Book:

The selection when editing a batch is: Respond to Prompts at the Batch Level, then (Default), then Respond to Prompts at the Report/Book Level, and then Respond to Prompts at the Grid Level.

The selections are shown only when necessary. They are not shown if multiple references to a variable or prompt exist.

Users can respond to a prompt once, and the same value will be used for both responses, or they can select “Respond to Prompt at Grid Level” in the drop-down, press Apply and enter different values for each prompt.

The Source column shows what artifact the prompt is on. When identical prompts are found and only one prompt response is presented, the Source column shows an asterisk (*) to indicate that the prompt response applies to all prompts of that type.

The ability to select the level at which to respond to prompts is available only in Planning and Budgeting Cloud Workspace. In Reporting Studio, the Respond to Prompts dialog box always shows all member selection prompts and one reference to each variable.