How to Cascade a Report
  • 1 Minute to read
  • Dark
    Light
  • PDF

How to Cascade a Report

  • Dark
    Light
  • PDF

Article summary

To create a cascade report, you begin by opening a View that has the dimension on the row axis.

  1. Select the Analyze task and the Data subtask.

  2. Select the View.

  3. Select the Design Report, Report subtask.

  4. Select the entire spreadsheet as shown below.

    Note:
    It is important when using Cascade Reports to select the entire spreadsheet before selecting the Design Manager to ensure the dimensions are represented correctly if the cascade option is used.

    ModelingImages401to450image4081.png

  5. Click Design Manager.

  6. On the Design Manager page, Cascade is available for row dimensions. Select the Cascade checkbox for the Company dimension.

    ModelingImages401to450image4091.png

  7. If Account was selected, Company would have automatically been selected as well because Account is nested (to the right of Company). Nested dimensions are referred to as inner dimensions. The outer dimension for this report is Company. Click the Selection icon to specify the Cascade options.

    ModelingImages401to450image4102.png

    ModelingImages401to450image4112.png

    For details on the Cascade Options, see Cascade Options and Filters.

  8. Click Select Member.

  9. The Member Selection page appears. Click on DecisionWorks Corporate and then click Select.

    ModelingImages401to450image4141.png

  10. Click the Selection icon. Select Filters.

  11. Select Sel+ Children of DecisionWorks.

    ModelingImages401to450image4151.png

    For details on the Cascade Filters, see Cascade Options and Filters.

  12. Click Update. Notice that the Company dimension is preceded with “Cascade”. This indicates that it is a cascading dimension.

    ModelingImages401to450image4311.png

  13. Apply formatting. For example, highlight cells in green and make the font larger.

  14. Click Save.

  15. Enter a name for the report and click save.

  16. Select the Run subtask to execute the report and apply cascading functionality.

    Notice that the parent company (DecisionWorks Corporate) is at the bottom of the report. When including a parent member as was done in step 11, the parent is always displayed at the bottom of the report.

    ModelingImages401to450image421602x5181.png

    ModelingImages401to450image417602x4951.png

    ModelingImages401to450image4181.png

    ModelingImages401to450image4191.png

    ModelingImages401to450image420604x4711.png

    For complete information on the features within Cascade, see Cascade Reporting.


Was this article helpful?