PC Account Dimension

Return to Profit Center Model Overview.

Elements in the PC Account dimension are account hierarchies within internal profit and loss statements used to allocate amounts between profit centers and cost objects. This dimension can be configured to meet reporting and planning requirements with the Profit Center 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 for the usage of localized translations of the accounts. Usually, there is at least one hierarchy with the profit or balance sheet result as the topmost aggregation. To provide multiple views of the profit and loss figures, parallel hierarchies can be set up.

This dimension is intended for the internal reporting of profit and loss. The PnL Account dimension used in the Profit and Loss model, in contrast, is used for statutory reporting. The PC Account dimension can be set up identically to the PnL Account dimension or entirely differently – whatever makes the most sense to manage the organization.

The PC 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 (Financial Consolidation) 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.

Inter Profit Center

Indicates whether the account contains inter-profit-center relations. Valid values are:

0: The account does not have inter-profit-center relations

1: The account has inter-profit-center relations.

This flag is currently not used by the Profit Center model. Custom reports or interfaces may take advantage of this attribute. (numeric)

Cost Object Breakdown

Indicates whether the account is broken down by cost objects. Valid values are:

0: The account is not broken down by cost objects

1: The account is broken down by cost objects

Inter Cost Object

Indicates whether the account contains inter-cost-object relations. Valid values are:

0: The account does not have inter-cost-object relations

1: The account has inter-cost-object relations.

This flag is currently not used by the Profit Center model. Custom reports or interfaces may take advantage of this attribute. (numeric)

Allocation

Indicates whether the account is used to store allocation results. Valid values are:

0: The account is not used to store allocation results

1: The account is used to store allocation results

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.

PTargetRestriction

Slice within one or more of the business dimensions receiving transferred data; only for planning versions.

Example: 'Partner Entity':'~','Partner Profit Center':'~','Cost Object':'~','Partner Cost Object':'~'

ACalculation

Indicates which rule is implemented on element for Actual version.

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 Actual version.

Example: 'Partner Entity':'~','Partner Profit Center':'~','Cost Object':'~','Partner Cost Object':'~'

AggregationType

Semi-additive measure behavior. (string)

Valid values are:

  • (empty): Regular additive behavior
  • First: First child
  • Last: Last child
  • Avg: Average of children

Updated August 28, 2023