Financial Statement Template

Owned by
Migration
Last updated: Jun 01, 2015 by
Andy Heller (Deactivated)
3 min read

Introduction

This template is the most widely used and appreciated template in CXO-Cockpit. It is mostly used for classic statements such as a profit and loss and balance sheet, with drill-down to the underlying detail. Upon selection of a line, the right top pane shows the trend over a number of time periods. Upon the selection of a column in the trend, the bottom section gives the detail with drill down to any dimension available.

CONTENT

Parameters

The Report Parameters define the look & feel and behavior of a report. On the screenshot below you can see the parameters numbers. These numbers refer to the parameters as displayed in the Basic Parameters and Advanced Parameters table. Next to Basic and Advanced Parameters there are also Generic Report Parameters

Basic Parameters

ParameterDescriptionMandatory

1. Rows

This list defines the rows the report. This list influences most of the look and feel of the report. All list formatting options are supported.Yes
2. Reference CategoriesA list of items that will be used as Reference Categories in the report. Each item can be a combination of members from the dimensions associated with the list (usually Category, Year and/or Period. Formulas are not allowed.Yes

Advanced Parameters

Parameter

Description

Mandatory

3. Default Selected Item

Indicates the Item from the List that will be selected / highlighted upon opening of the report. If none is selected, the last row will be highlighted.

No

4. Side Trend

List of items that determines the X-axis of the trend in the Side Trend (usually associated with the Year and the Period dimension).

Yes

5. Label Base Category

Dynamic Label that can combine the description of dimension-members and free text. The member-description can be obtained by putting the 3-character dimension abbreviation between square brackets (e.g., [CAT] for the Category dimension). Note: When using free text, don't use the "[" or "]" characters as these are reserved for Dynamic Label Expressions.

Yes

6. Default Selected Variance

Enter Variance % if you want to open the report with a variance percentage column. Enter Variance if you want the absolute variance as a default view.

No

7. Variance Style

The variance style has the following options: Arrow, Background, Bar, BarAndValue, Border, Font, None, TrafficLight, TrendArrow

Yes

8. Replace Blanks By

Enter a character or string that you want to see instead of missing values.

No

9. Use Inline Drill

Provides an option to use inline drill for Rows List members.

Yes

10. Show Variance as Better/Worse

Better/Worse variance representation can be used to display positive variance with positive sign and negative variance with minus sign.

No

11. Variance Percentage Precision

Defines the number of decimals used for presenting the Variance Percentage values.

Yes

12. Breakdown Member Depth Limit

This parameter determines the number of hierarchy levels you want to make available for each of the relevant breakdown-dimensions in the lower-right part of the report. Increasing this number may affect performance.

Yes

13. Default Breakdown Dimension

This value sets which dimension will be selected by default in the breakdown area.

Yes

14. Variance Threshold

Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than the 1st threshold value, then Red (indicating an unfavorable variance) is used. If the Variance is greater than the 2nd threshold value, then Green (favorable variance) is used. And if Variance is between the 2 threshold values, Orange (neutral variance) is used. Use, for example, -200;300 for absolute thresholds or -10%;20% for relative thresholds.

Yes

See Also

Functional end-user description of template:Financial Statement