BS Account Dimension (Financial Consolidation)
Return to Financial Consolidation Model Overview.
Elements in the BS Account
dimension comprise account hierarchies in the financial statement for the balance sheet. You can configure the BS Account
dimension to meet the reporting and planning requirements for the Financial Consolidation
model.
Account numbers should be used as elements; readable names should be stored in the Name
attribute. This simplifies the import and export of financial data, minimizes the impact of amendments of the readable names, and allows you to use localized translations of the accounts. The top-level hierarchy generally comprises Total Assets
and the Total Equity and Liabilities
. You can set up parallel hierarchies to provide multiple views of balance sheet figures.
The BS Account
elements can be configured through their attributes:
Attribute |
Description |
Name |
The account's display name, which can include localized translations. This attribute is visible in reports and does not have any hard-coded behavior (string). |
ID_Name |
The technical element name of the article and its readable name. If localized translations are provided for the |
Description |
A detailed description of the account. This attribute may include definitions of the amounts booked in the account or provide instructions for planners. Localized translations can also be provided (as a string). |
Type |
Valid values are |
Conversion Type |
Specifies the exchange rate used for currency conversion. Valid values are base elements of the See Fact Cube Using Currency Conversion (Financial Consolidation) and Configuration of Conversion Types. |
FXDiff Account |
FXDiff (Foreign Exchange Differences) represents the difference between the amount converted at historic rates and the value in local currency converted at the month-end rate. This attribute applies only to accounts with the historic conversion type, and its value must refer to a base element in the BS Account dimension. |
Movement Schedule |
The movement schedule is the Subset of elements of the |
Intercompany |
Indicates whether the account contains intercompany relations. Valid values are:
This flag is currently not used by the |
Consolidation Rule | Consolidation rule by which this account is eliminated in the financial consolidation procedure. This must be a base element of the Consolidation Rule dimension which is defined by one of the elimination rule functions (e.g., Elim.Assets , ElimX.Assets , Elim.Liabilities , ElimX.Liabilities ). If the account is not eliminated or is eliminated by a consolidation rule using a fact selector, this field must remain empty. When this attribute is populated, the Clearing Account attribute must be populated, too. |
Clearing Account |
Another balance sheet account or profit and loss account, to which the amount from the balance sheet account is counterbooked. Both sides of a consolidation rule must use the same clearing account to ensure that the amounts from the reporting entity and the partner entity balance out. his field must remain empty if the account is either not eliminated or is eliminated using a consolidation rule with a fact selector. When this attribute is populated, the Consolidation Rule attribute must be populated, too. |
Format |
The number format for this account will be driven by the database. Database formatting will be implemented in the near future (string). |
PCalculation |
Defines the calculation for the element; only for planning versions. |
PCalculationDependencies |
Indicates which cube is the source of transferred data; only for planning versions. |
PTargetRestriction |
Slice within one or more of the business dimensions receiving transferred data; only for planning versions. Example: |
ACalculation |
Defines the calculation for the element; only for the |
ACalculationDependencies |
Indicates which cube is source of transferred data; only for Actual version. |
ATargetRestriction |
Slice within one or more of the business dimensions receiving transferred data; only for planning versions. Example: |
DCS Check Account |
Used to refer to another |
DCS Condition |
Used to specify a calculated debit-credit-shift account. Valid values are empty, >=0 , and <0 (reserved for future use). |
DCS Data Account |
Used to refer to another base-level BS Account to define the value of the debit-credit-shift account if the DCS Condition is met. If DCS Condition is not set, this attribute should be empty, too (reserved for future use). |
Separate Statement |
Exposed on the separate financial statement reports. |
Consolidated Statement |
Exposed on the consolidated financial statement reports. |
Separate Movement Schedule Report | Name of the detail report that shows the movement schedule for the consolidated financial statement for this account. Example: Reports/Financial Consolidation Separate Property, Plant and Equipment.wss. It is left empty, if this account does not have a movement schedule report. (string) |
Consolidated Movement Schedule Report | Name of the detail report that shows the movement schedule for the separate financial statement for this account. Example: Reports/Financial Consolidation Separate Property, Plant and Equipment.wss. It is left empty, if this account does not have a movement schedule report. (string) |
Please note: Make sure you do not delete the following elements:
- All BS Accounts
- ~
- Unassigned
The following accounts must be placed in account settings:
Account | Value | Description |
bs_account_assets | 100000 | Top level account for reports. Must be an element from BS Account dimension (string). |
bs_accounts_equity | 210000 | Top level account for reports. Must be an element from BS Account dimension (string). |
bs_accounts_kpis | 910000 | Parent element of KPIs to be shown on reports. Must be an element from BS Account dimension (string). |
bs_account_liabilities | 200000 | Top level account for reports. Must be an element from BS Account dimension (string). |
business_combinations_transaction_type | BCmb.T999 | Transaction on business combinations (string). |
Additionally, they must conform to the sign standard (see full article for more detail).
If you do not meet the above constraints, the implementation relying on them may no longer fully work.
For more details on the PCalculation
, PCalculationDependencies
, PTargetRestriction
, ACalculation
, ACalculationDependencies
and ATargetRestriction
attributes see the KPI Calculations (by Version) for Balance Sheet and Balance Sheet (Segment) Cubes article.
Updated September 27, 2024