Group Aggregate statements

Select Reporting > Group Reports and then select one of these reports:

  • Group Aggregate Assets
  • Group Aggregate Assets Analysis
  • Group Aggregate Liabilities
  • Group Aggregate Liabilities Analysis
  • Group Aggregate Income Statement
  • Group Aggregate Income Statement Analysis

In the Group Aggregate Assets, Group Aggregate Liabilities, and Group Aggregate Income Statement reports, you can view the contribution of each entity within a group to each group account. Aggregated entity values for each account are displayed in the Consolidated Financial Statement column.

You can use the Group Aggregate Assets Analysis, Group Aggregate Liabilities Analysis, and Group Aggregate Income Statement Analysis reports to verify entity balances at the group level.

In the analysis reports, you can filter by an entity or multiple entities to show only the selected entities in columns and the aggregated values for the selected entities for the last three columns. All entities that belong to the selected group are selected by default. You can remove the unnecessary entities from the view. If you change the group in the context, the entities to select also change.

By right-clicking a value in the Consolidated Financial Statement column, you can select these options:

  • Cell Information

    Provides details about the source of a cell value such as a cube name, coordinates, and whether the cell is rule-calculated, entered, or aggregated. You can switch between captions and their technical names by clicking View and selecting the appropriate option. By clicking View Source, you can view and then copy the displayed value source information.

    This option is not available in the Group Aggregate Assets Analysis, Group Aggregate Liabilities Analysis, and Group Aggregate Income Statement Analysis reports.

  • Account Analysis

    Shows the appropriate Account Analysis report.

By right-clicking a value in any of the entity columns and the Adjusted Company Data column, you can select the Cell Information option.

You can use the zero suppression function on rows or columns, or both. Select Rows > Suppress Zero Rows, or Columns > Suppress Zero Columns, or both.