Cascading Reports

You can create separate reports for any or all of the members of one or more dimensions in a report based on an ad hoc grid.

You can then cascade these reports separately across the worksheets of an Excel workbook.

To cascade a report from an ad hoc grid:

1. Open an ad hoc grid on the worksheet.

2. From the provider ad hoc ribbon in the Analysis section, select Cascade .

3. In the Smart View panel to the right of the worksheet, click next to each dimension to launch the Smart View Member Selector dialog box.

4. Select the members for the dimension for which you want to create reports, and then click Apply.

   One report will be generated for each member you select.

5. Click OK to begin cascading.

   The resulting reports are created on separate worksheets in the current workbook. Each worksheet tab is named for the dimensions and members of the report it contains. Click a worksheet tab to view a report.

Note:

The names on the worksheets created as a result of cascading have a 30 character limit. Any characters over 30 are truncated.