Group Account Analysis

Select Reporting > Group Reports > Group Account Analysis.

Data in the final balance of an account may come from different sources and is stored at different levels in an account. In the Group Account Analysis report, you can view a group account's details at different levels. You can view at which levels data is stored and from which intercompanies it comes. For example, data that is generated in Journal Management is stored and displayed at the Journals level.

At the Journals level, you can drill through to view the details of individual journals. A drill-through to journals is possible even if an account value is 0. That can occur when an aggregated debit equals an aggregated credit in posted journals on a selected account.

By right-clicking a value in the report, you can select the Cell Information option. This option 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.

Note: The Cell Information option is not available for values that have been generated in Journal Management.