Specifying Report Intersection Levels

In the Context tab of the drill-through report editor, when you define intersection levels for a drill-through report, you set the common thread that ties this drill-through report to other drill-through targets.

See Determining Where to Set an Intersection Level.

  To specify report intersection levels:

  1. In the Context tab of the drill-through report editor, click Add.

    The Select Hierarchy dialog box is displayed.

  2. In Select Hierarchy, navigate to a hierarchy, measure hierarchy, or recursive hierarchy that you want to include in the drill-through report, select it, and click OK.

    The hierarchy is displayed under Intersections in the drill-through report editor.

    You may also add hierarchies by dragging them from the Metadata Navigator directly to the area under Intersections in the Context tab of the drill-through report editor. When you use this method, you need not click the Add button.

    Note:

    All hierarchies must be selected from the same relational source. You may add one or more hierarchies for all drill-through intersections you want to define in this report.

    Note:

    Hierarchies created from Performance Management Architect sources are not supported as drill-through intersections.

  3. In the expanded hierarchy under Intersections, select the check box next to the member name that you want to specify as a drill-through intersection.

    Note:

    You can specify any level in the hierarchy, including the top level, as a drill-through intersection.

  4. Repeat step 2 through step 3 to add hierarchies for all drill-through intersections that you want to define.

    Note:

    In Smart View only: If you select only one hierarchy, the drill-through report will be available from the corresponding member cells as well as from the data cells. This is known as “member drill-through.”

  5. If you selected recursive hierarchies for this drill-through report and want to modify the default intersection, which is level 0, click Advanced Settings to open the Recursive Hierarchy Settings dialog box.

    Note:

    If a recursive hierarchy is also a measure hierarchy, it is treated as a regular hierarchy in the drill-through report editor, and the Advanced Settings button is not enabled.

    See Specifying Intersection Levels for Recursive Hierarchies for information.

  6. Select the Report Contents tab to define the report type and specify the accompanying parameters, described in Defining the Report Type and Customizing the Report.