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 |
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 |
Conversion Type |
Defines which exchange rate is used curing currency conversion. Valid values are base elements of the 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:
|
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