Entity Account Analysis

Select Reporting > Entity Reports > Entity 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 Entity Account Analysis report, you can view an account's details at different levels. For example, imported data is stored and displayed at the Imported Data level and data that is generated in Journal Management is stored and displayed at the Journals level.

At the rollover levels and 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.