COSTCNTR

This table describes the dimension:

Value Description
Description This dimension is used to show the cost center hierarchy. It has to be considered that the hierarchy and its aggregated levels must match the P/L account structure according to cost of sales method (data connections between the SALES and COST cubes). All cost centers are adding up into the AllCostcenters top element. The cost centers used in the configuration are:
  • Material
  • Production
  • Sales
  • Research and Development
  • Administration
Maintenance The structure can be added or changed according to specific needs of the customer

The mapping to the P/L account structure may need adjusting to make all data connections between SALES and COST cubes work

Attribute table 1

Attribute field 1: ElemType - Type of element (numeric or string)

Attribute field 2: Name - Short description in (English)

Attribute field 3: OrderPos - Order position for report listing

Maintenance Manually
Attribute table 2

Attribute field 1: English - English Description

Attribute field 2: German - German Description

Attribute field 3: French - French Description

Attribute field 4: Spanish - Spanish Description

Attribute field 5: Italian - Italian Description

Subsets None