Working with shared prompts

Use shared prompts to apply filtering to analytical queries and compound dynamarts.

About this task

In analytical queries, you use prompt groups that include shared child query prompts, newly added simple prompts, or prompt hierarchies. You can group prompts of the same type so that all the prompts within one prompt group receive the value passed to this group.

To manage shared prompts in analytical queries or compound dynamarts:

Procedure

  1. With an active query in the query editor, either select Query > Manage Prompts or open the Prompts pane on the Design tab.
    On the Prompts pane, you can see the child query prompts or newly added simple prompts or prompt hierarchies.
  2. To add a simple prompt, perform the steps from Adding simple prompts.
    The newly added simple prompt is automatically added to a newly created prompt group that borrows its name.
  3. To add an existing prompt hierarchy, perform the steps from Adding existing prompt hierarchies.
    The newly added prompt hierarchy is automatically added to a newly created prompt group that borrows its name.
  4. To move a prompt from the default group to another group:
    1. From the Available prompts list, select an item that you want to add to a group.
    2. From the Prompt Group list, select a group to which you want to add the selected item.
    3. Click Add to Group. The selected item is added to the prompt group.
    Note: You can only group prompts of the same type and prompt hierarchies with the same resource.
  5. To remove a prompt from a group:
    1. From the Prompt Group list, select an item that you want to remove.
    2. Click Detach Prompt. The selected item is detached from the prompt group.
  6. To rename a prompt group:
    1. From the Prompt Group list, select the prompt that you want to rename.
    2. Click Rename Prompt Group.
    3. In the Prompt Group window, specify the name and string to display and click OK.
  7. To change the order of the prompt groups in the Prompt Group list:
    1. From the Prompt Group list, select the node of the prompt group or a prompt in the group.
    2. Click Move Prompt Group Up or Move Prompt Group Down.
  8. If you work in the Manage Prompts window, click OK to close the window.

Results

To view the prompt values that you specified when you last ran the query, select Query > View Prompt Values.