CF Account Dimension

image_pdfimage_print

Return to Cash Flow Model Overview

Elements in the CF Account dimension are account hierarchies in the financial statement for cash flow. This dimension can be configured to meet reporting and planning requirements with the Cash Flow model.

The base elements of this dimension are either single ledger accounts or 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 of Adjustment. Valid values are base elements of the Conversion Type dimension, e.g. Average,  Month End, Month Start, and ~. Cash flow accounts usually use currency conversion with average rates. Use ~ to suppress the currency conversion, e.g. for statistical figures like number of heads. (string)

See Fact Cube Using Currency Conversion 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)

image_pdfimage_print
Was this post helpful?
NoYes (No Ratings Yet)
Loading...