Using the Drill and Slice Properties Frame

The Drill and Slice Properties frame is used to configure local filters into a hierarchy. Local filters that are excluded from the hierarchy are, however, made available in Step 6: Configure Filters of Dashboard Studio.

*  To configure Drill and Slice hierarchy path properties:

  1. In Interactive Reporting Studio , navigate to QIQ Filter Properties and create local filters.

  2. Add a marker column to row labels and the x-axis of pivots and charts that are included in the Drill and Slice operation.

    The marker column is replaced by columns of the hierarchy during drill and slice.

  3. After pivots and charts are configured with marker columns, move to Drill and Slice Properties.

  4. From Hierarchy Source, select the section that contains the local filters that were created in QIQ Filter Properties.

  5. Optional: Configure the hierarchy source by selecting one or both proposed options:

    • First item is selected by default

    • Filters are retained when drilling up

  6. Move selected filters between Available Columns and Hierarchy Columns by clicking Next button and Back button.

  7. Optional: Reorder selected Hierarchy Columns by selecting a column and clicking Move Up button or Move Down button.

  8. Click Apply.

    The hierarchy and all frames that use it are configured.