Adding existing prompt hierarchies

You can add an existing prompt hierarchy that is stored in a repository or file to a visual query, analytical query, dynamart or compound dynamart.

1. In the query editor, switch to the Design tab.
2. Click the arrow on the New Prompt Hierarchy () button and select Add Prompt Hierarchy.
3. In the Prompt name field, specify the name that you want to use for the prompt hierarchy.
4. In the Display string field, specify the text that you want to display when the query is run.
5. Click the ellipsis (...) button to navigate to and select the prompt hierarchy that you want to add.
   The path to the prompt hierarchy that you selected is displayed in the Resource field.
6. Select the type of the resource.
   • Select Embedded to store the prompt hierarchy with the query or dynamart.
   • Select Linked to store the link to the prompt hierarchy in the query or dynamart.
7. Optional: If you add a prompt hierarchy to a visual query or dynamart, in the Prompt Level column, you can select the required level of the prompt hierarchy for each query column.
8. Click OK to close the Prompt Hierarchy dialog and return to the Design tab of the query editor.
   The prompt hierarchy that you added is displayed in the Prompts pane.
9. Assign prompt hierarchy levels to selected columns:
   • In a visual query or dynamart, assign the selected levels of the prompt hierarchy to the query columns:

     1. In the Prompt Assignments pane, select a column.

     2. Click the down arrow in the Prompt column to select the prompt hierarchy level for the column.

   • In an analytical query or compound dynamart, add the prompt hierarchy to a group of shared prompts to assign it to the columns of the child queries:

     1. In the Transformations pane, double-click Filter to open the Dynamart Filter wizard.

     2. Select Enable filtering.

     3. From the Filter type area, select Prompt Hierarchy Filter. Click Next to open the Assign prompt hierarchy levels to columns page.

     4. Select a column and click the down arrow in the Prompt column to select the prompt hierarchy level for the column.

     5. Click Finish to close the Dynamart Filter wizard.

        Note: You can assign a prompt hierarchy to a calculated column that you added to the query.
10. To edit a prompt hierarchy, select it from the list of available prompts in the Prompts pane and click Edit Prompt.
11. To delete a prompt hierarchy, select it from the list of available prompts in the Prompts pane and click Delete Prompt.
12. To update data of the linked prompt hierarchy, select it in the Prompts pane and click Refresh linked prompt hierarchy.
13. To edit the level structure or data source object for the prompt hierarchy, select it in the Prompts pane and click Open in prompt hierarchy editor ().
    The prompt hierarchy is opened in the Prompt Hierarchy editor.