Return to Projected Balance Sheet Model Overview
This report contains the relevant configuration to run projections, it contains the mapping of the Profit and Loss (PnL) statements to the Balance Sheet (BS) statements.
Report Heading
The screenshot below points out the heading area of the Projected Balance Sheet Projection Configuration report. The logo can be changed in Administration; see Configuring Design Elements for more on report design.
The heading area of the report displays the following fields:
| Field | Description | Implementation |
|
Title |
Name of the report. |
Name of the report in Report Designer |
Parameters
The content of the report can be customized using these parameters.
The available options are described below:
|
Parameters |
Description |
Implementation |
| Batch Procedure Configuration | Select the projection procedure. | Batch Procedure Configuration dimension filter for Executable attribute equals 1 |
|
Version (Combobox) |
Select the version used to execute the projection. | Version dimension, filter for Stylesheet attribute equals FC |
| Month (Combobox) | Select a reporting period (can be a year, or a month in a given year). | Elements matching the pattern yyyy-MM or FYyyyy-MM of Month dimension |
|
Legal Entity (Combobox) |
Select one single legal entity or any consolidated element. | Legal Entity dimension |
| Show Filter (checkbox) | When clicked reveals the filters. | Filters are attributes of Batch Procedure Configuration dimension |
| Start Procedure (button) | Click to run the procedure. | |
| Get Job Status | Visible if the job is currently running. | |
| Status message and icon |
Empty: job has not been started yet Running: job has been started and did not finish within a short timeout period. Use Failed: job has failed. Check the execution log in Integrator – Monitor Completed with Warnings: job has succeeded, but one or more warnings have been raised during the execution. Check the execution log in Integrator – Monitor Completed successfully: job succeeded without any warnings or errors. |
for detailed information.Report Columns
The columns displayed in the report depend on the selections made in the Parameters area. The screenshot below shows a report displaying the name of various procedures.
Below are descriptions of the columns in the Projected Balance Sheet Projection Configuration report. Note: the filter columns are only visible if the Show Filter option in the Parameters area is checked.
|
Field |
Description |
Implementation |
| Level.Step | Defines the execution order of the steps. Valid values are whole numbers (e.g. 0, 1, 2, 3 …) before and after the decimal point (e.g. 1.1, 1.2, 1.3…). The first number represents the level of the standard procedure and the second is for the step. | Level.Step attribute of Batch Procedure Configuration dimension |
| Enabled | Indicates whether a particular step or procedure is enabled or disabled. Restricted to either 1 or 0 (Checked or unchecked, numeric). | Enabled attribute of Batch Procedure Configuration dimension |
| Name | Name of the projection procedure. | Name attribute of Batch Procedure Configuration dimension |
| Duplicate | Button to duplicate the projection step. | Duplicates all attributes in Batch Procedure Configuration dimension and content in Projection Configuration cube. |
| Delete | Button to allow for the deletion of the projection procedure. | Removes the element from the Batch Procedure Configuration dimension |
| Description | Editable field with a short description of the projection procedure. | Description attribute of Batch Procedure Configuration dimension |
| FilterVersionPattern | Defines which versions a particular step applies to using regular expressions. Examples: ^.*$,
|
FilterVersionPattern attribute of Batch Procedure Configuration dimension |
| FilterMonthFrom | Defines the months a particular step applies to using the beginning of a date range. Example: 1900-01 (starting from January 1900). |
FilterMonthFrom attribute of Batch Procedure Configuration dimension |
| FilterMonthTo | Defines the months a particular step applies to using the end of a date range. Example: 2099-12 (ending on December 2099). |
FilterMonthTo attribute of Batch Procedure Configuration dimension |
| FilterLegalEntityFrom | Defines the legal entities a particular step applies to using the beginning of an alphanumeric range. Example: 0 (could be any number, uppercase letter or lowercase letter). |
FilterLegalEntityFrom attribute of Batch Procedure Configuration dimension |
| FilterLegalEntityTo | Defines the legal entities a particular step applies to using the end of an alphanumeric range. Example: zzzzzzzz (could be any number, uppercase letter or lowercase letter). |
FilterLegalEntityTo attribute of Batch Procedure Configuration dimension |
| Configuration Report | Link to PnL Account Configuration report. |
Updated August 23, 2024