INTERCO

This table describes the dimension:

Value Description
Description This dimension is to specify all intercompany relations with internal and external partners. External relationships can be broken down into groups of customers or even a single customer. The hierarchy of all internal partners reflects all relevant companies from the corporate group structure. Since planning of sales is not based on customer level, a dummy unassigned element has been included outside the main hierarchy. Any additional aggregation outside TotalPartner should not be configured.
Maintenance The structure can be added or changed according to specific needs of the customer.
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 N-Elemente Sales

The subset is a static subset which contains all internal and external partners on a base level.

Only the unassigned base element is not part of the grouping. The subset is necessary to calculate the average price in the SALES cube and must be adjusted according to appropriate changes to the INTERCO dimension.