CF Account Dimension

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)

Updated February 7, 2024