Build Dynamic Reports Using Report Sets

A Dynamic Report consists of a report grid. For example, an income statement report might be shown on the column axis and income statement accounts along the rows axis. At the intersection of each member along each axis, a cell displays the measure data for the selection of company and department.

You can use Report Sets as rows or column axis members in a Dynamic Report. Report Sets are individually designed on a specific dimension. Once created they can be referenced in multiple reports. Report Sets on the row of a Dynamic Report are referred to as Row Sets. Report Sets on the column axis of a Dynamic Report are called Column Sets.

A few examples of Report Sets are; Income Statement, Balance Sheet, and Cash Flow statements on an Account dimension or yearly, quarterly, and monthly on a Time dimension.

When a Static or Dynamic Report Set is used on the row axis of a Dynamic Report, the primary dimension which is used in the Report Set is reflected as the column header in the report. This is also applicable to the Dynamic Report Set used in combination with other Report Sets and dimensions.