You can design a report to display detail rows and columns of a grid at the request of the end user. You do this by enabling the expansion of a dimension that has parent-child relationships among its members. For example, if you enable the Time dimension to expand, users can expand a row that displays quarters into months.
Users access detail rows and columns by selecting summary rows and columns from reports that are displayed.
To set up access to detail data within a report:
Select the row or column headings for which you want to enable expansion.
Select the Allow Expansion check box in the Heading Row or Heading Column Properties sheet.
When Hybrid Data is available for a base-level member in Oracle Essbase, an expansion arrow is displayed next to the base-level member and you can expand into Hybrid Data. Expansions are not allowed on rows with line-item-detail or supporting detail, or on columns containing a row with line-item-detail.
Double-click the dimension to select members to expand. For more information on selecting members, see Selecting Members for Report Designers.