PnL Account Dimension

Return to Profit and Loss Model Overview.

Elements in the PnL Account dimension are account hierarchies in the financial statements for profit and loss and profit appropriation. This dimension can be configured to meet reporting and planning requirements with the Profit and Loss 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 at least one hierarchy with the profit or balance sheet result as topmost aggregation. To provide multiple views of the profit and loss figures, parallel hierarchies can be set up.

The PnL 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 `Income` and `Expenses`. 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. Valid values are base elements of the `Conversion Type` dimension, e.g. `Average`, `Month End`, `Month Start`, and `~`. Profit and loss 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
Intercompany	Indicates whether the account contains intercompany relations. Valid values are: `0`: The account does not have intercompany relations `1`: The account has intercompany relations. This flag is currently not used by the `Profit and Loss` model. Custom reports or interfaces may take advantage of this attribute. (numeric)
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.

Updated August 25, 2023