Creating and Displaying Charts and Pivots on Drill and Slice Frames

Charts and pivots to be displayed in the Drill and Slice component must be associated with Drill and Slice frames, so that the data is drilled and sliced correctly.

Drill and Slice frame prototypes are available with the installation and are selected in Dashboard Studio, Step 2: Add and Rename Frames.

*  To create, add, and associate charts and pivots with Drill and Slice frames:

  1. In Interactive Reporting Studio , create the Interactive Reporting Studio documents to be used, including the template.

  2. Create the charts and pivots to be drilled and sliced.

    • Do not add the columns from your hierarchy

    • Add and position the marker column that the Drill and Slice component uses to substitute columns from the hierarchy (see Renaming the Marker Column)

  3. In Step 2: Add and Rename Frames of Dashboard Studio, add the frames upon which charts and pivots are to be displayed.

    The frames must be the frame prototypes available in Drillslice_component.bqy. These Drill and Slice frame prototypes are also available in the Frame_Library.bqy in the templates folder.

  4. Create Drill and Slice frames from a frame prototype:

    • Top Controls Drop Down

    • Top Controls Tabs

    • Side Controls Tabs

  5. In Step 3: Layout of Dashboard Studio, use Interactive Reporting Studio to drag the charts and pivots onto the frames.

  6. In Step 4: Associate Frames with Charts, Pivots, or Tables of Dashboard Studio, configure the features available for the charts and pivots.

  7. Click Associate button to associate the charts and pivots with the frame prototypes.