CF Account Dimension (Financial Consolidation)

Return to Financial Consolidation Model Overview.

Elements in the CF Account dimension comprose account hierarchies in the financial statement for cash flow. You can configure the CF Account dimension to meet reporting and planning requirements for the Financial Consolidation model.

There are two types of base elements in this dimension: single ledger accounts and reporting positions. Aggregations in the dimension represent the hierarchy that is used to form the reports. Account numbers should be used as elements, and readable names should be stored in the Name attribute, which simplifies the import and export of financial data, minimizes the impact of amendments of the readable names, and allows using localized translations of the accounts. Usually the cash flow statement comprises the three parts

  • Cash flow from operating activities,
  • Cash flow from investing activities and
  • Cash flow from financing activities

which are totalized to Total cash flow. Some customers extend this structure with the transition from cash funds at the beginning of the period to cash funds at the end of the period

The CF Account elements can be configured through their attributes:

Attribute

Description

Name

Readable name of the account. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

ID_Name

Technical element name of the account as well as the readable name. If localized translations are provided Name attribute, this attribute will also become localized. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string, calculated)

Description

Long text description of the account. This attribute can contain a definition of the amounts booked to the account or instructions for the planners. Localized translations can be provided. (string)

Type

Valid values are Proceeds and Payments. If other values are stored, such as statistical figures or KPIs, then this attribute must be empty. (string)

Conversion Type

Defines which exchange rate is used curing currency conversion. Valid values are base elements of the Conversion Type dimension, e.g. Average, Month End, Month Start, Historic and ~. Balance sheet accounts usually use currency conversion with month end or historic rates. Use ~ to suppress the currency conversion, e.g. for statistical figures like number of heads. (string)

See Fact Cube Using Currency Conversion (Financial Consolidation) and Configuration of Conversion Types.

Format

Number format for this account to be driven by the database. (string)

Calculation

Indicates which rule is implemented on the element. (string)

CalculationDependencies

Indicates which cube is the source of transferred data. (string)

Symbol

Additional symbol to be used to emphasize the meaning of the reporting position in the report, such as +, -, +/- and =. Not used as of now. (string)

Aggregation Type

Semi-additive measure behavior. (string)

Valid values are:

  • (empty): Regular additive behavior
  • First: First child
  • Last: Last child
  • Avg: Average of children

Segment Statement

Exposed on the Operating financial statement reports.

Region Statement

Exposed on the Geographical financial statement reports.

Please note: Make sure you do not delete the following elements:

  • All BS Accounts
  • ~
  • Unassigned

Additionally the account cf_account (value:400; string) must be placed in account settings.

If you do not meet the above constraints, the implementation relying them may no longer fully work.

Updated August 28, 2023