Generate and review Balance Sheet Consolidated report which shows contribution of individual entities and breakdown of elimination entity by audit.
Once you have selected the parameters, the report displays:
- Columns are divided into two sections:
- Section 1: The first set of columns shows Entities directly under the Entity parameter selected.
- Section 2: The Elimination entity of the selected Entity parameter, where EntityType = Elimination. Additionally, the Audit column displays members under the member tagged as #Contribution.
- Rows display account Balance Sheet details.
The rows that have 0 as a value are suppressed.
Fixed dimensions
The fixed dimensions of the report include:
| Dimension | Member(s) |
| Currency | Parameter selected. |
| DataView | Member tagged as #AllDataviews. |
| Date | Parameter selected. |
| Intercompany | Member tagged as #TotalGroup. |
| Measure | Member tagged as #Amount |
| Movement | Member tagged as #Closing |
| Scenario | Member selected |
| Any additional dimensions | Default reporting member. |
View Contribution Detail report
Under each Entity in the initial section of the report, there's a link labeled Contribution. Select this link to open the Contribution Detail report and view the Balance sheet by the audit member.
View Journal Detail report
Under each Audit member in the second section of the report, there's a Journal link. Select this link to open the Journal Detail report, which displays the Balance sheet data for the elimination entity by Intercompany members.
View data interactions
Within the report, right-click on any cell and select View Data Intersections. This opens another report that displays data that makes up the cell you selected.
For example, if you are looking at a parent Entity, you will see all the child Entities that make up this data value.
Note: You will only be able to see the data intersections for standard consolidation dimensions. Any additional dimension (for example, Products) wouldn't be displayed.