Building a prompt hierarchy filter

A prompt hierarchy filter allows you to filter query results using a prompt hierarchy that is used in the query.

About this task

Use the Dynamart Filter wizard to build a prompt hierarchy filter.

Procedure

  1. Open the Dynamart Filter Wizard, select the Enable filtering check box, select Prompt Hierarchy filter and click Next.
  2. On the Assign prompt hierarchy levels to columns page, use the Prompt column to select the prompt hierarchy level for the column.
  3. Once you have finished building the filter, click Finish.
    The Dynamart Filter Wizard closes and the query results are filtered.