Projected Balance Sheet Projection Configuration

image_pdfimage_print

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 Get Job Status button to check whether the job has terminated.

Failed: job has failed. Check the execution log in Integrator – Monitor   for detailed information.

Completed with Warnings: job has succeeded, but one or more warnings have been raised during the execution. Check the execution log in Integrator – Monitor  for detailed information.

Completed successfully: job succeeded without any warnings or errors.

 

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: ^.*$

^(Actual|Budget)$

 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.  

 

image_pdfimage_print