You can create a drill-through intersection on a recursive hierarchy, specifying the generation or level that will participate in the report. The drill-through report can be viewed in Smart View or Spreadsheet Add-in.
For recursive hierarchies, the default drill-through intersection is level 0.
See Recursive Hierarchies for information on recursive hierarchies.
To specify the drill-through intersection generation or level for a recursive hierarchy:
Complete step 1 through step 5 in Specifying Report Intersection Levels.
In Recursive Hierarchy Settings, under Generation/Level, click in the cell for the appropriate recursive hierarchy row and specify whether the intersection for this drill-through report will be based on Generation or Level.
The default setting is Level.
Under Number, specify the generation or level number to use as the drill-through intersection.
The default setting is 0 (zero).
Repeat step 2 through step 3 for all recursive hierarchies that are included in the drill-through report.
Click OK to save the recursive hierarchy settings that you specified and return to the Context tab for the drill-through report editor.
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.