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 individual sheets. Each sheet tab is named according to the dimensions and members of the report it contains.

Note:

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

To cascade a report from an ad hoc grid:

  1. Open an ad hoc grid.
  2. In the Extensions menu, select Smart View for Google Workspace, and then select Ad Hoc.
  3. Select Analysis and then select Cascade.
  4. Under Cascade, select the required option:
    • Cascade - Same Spreadsheet to cascade all reports in the current spreadsheet
    • Cascade - New Spreadsheet to cascade all reports in a new spreadsheet
    • Cascade - Different Spreadsheets to cascade all reports in different spreadsheets

    The Cascade panel opens.

  5. In the Cascade panel, click Ellipses button next to each dimension to launch the Member Selector dialog.

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

    One report will be generated for each member you select. Based on your selection, the number of cascaded sheets is displayed at the bottom of the Cascade panel.

  7. Click Done to begin cascading.

    You will see temporary sheets getting created until all the reports are cascaded. The resulting reports are created on separate sheets in either the current spreadsheet, a new spreadsheet, or different spreadsheets based on your selection. Each sheet tab is named according to the dimensions and members of the report it contains. Click a sheet tab to view a report.

    Note:

    After the temporary sheets are created, if you do not see the final cascaded reports, check the pop-up blocker settings on your browser and make sure you allow pop-up windows to be launched for cascading reports.