BS Account Dimension
Return to Jedox Models Overview
Elements in the BS Account
dimension are account hierarchies in the financial statement for the balance sheet. This dimension can be configured to meet reporting and planning requirements with the Balance Sheet
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 there is one hierarchy Total Assets and the Total Equity and Liabilities as topmost aggregation. To provide multiple views of the balance sheet figures, parallel hierarchies can be set up.
The BS 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 article 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 and Configuration of Conversion Types |
Intercompany |
Indicates whether the account contains intercompany relations. Valid values are:
This flag is currently not used by the |
Format |
Number format for this account to be driven by the database. (string) |
PCalculation |
Indicates which rule is implemented on the element; only for planning versions. |
PCalculationDependencies |
Indicates which cube is the source of transferred data; only for planning versions. |
ACalculation |
Indicates which rule is implemented on element for |
ACalculationDependencies |
Indicates which cube is source of transferred data; only for Actual version. |
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 . |
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. |
Projected |
Indicates that a base level element is the subject of an automated projection and not to be manually planned. Valid values are empty, 0 and 1 (numeric) |
Updated February 7, 2024