Use

You use this procedure to aggregate hierarchies for automatic data collection into the consolidation system (SEM-BCS).

The hierarchies in operational systems can be structured at a deeper level than is supported in the consolidation system. You aggregate a source hierarchy by grouping several subordinate hierarchy nodes in one higher-level node. This summarization process is called aggregation.

The tool you use for aggregation is Mapping as it exists in the following data collection methods:

Flexible Upload

Load from Data Stream

For data collection using flexible upload or load from data stream, the system initially maps the source hierarchy in an internal structure. The system transfers this by using the mapping rules that you have defined in Customizing the data collection method, line for line to the internal structure of the target hierarchy.

To aggregate a hierarchy you employ the following mapping principles:

The system deletes the edges that have higher-level and subordinate nodes with the same name in the mapping result (internal structure of the target hierarchy).

The system deletes redundant edges in the mapping result.

To assign the master data to the nodes on which you have summarized the hierarchy, you use the following mapping principle:

The system deletes redundant edges in the mapping result (by first sorting the nodes in ascending order and then deleting all nodes that have the same name up to the first node).

Prerequisites

In the consolidation workbench, you have made the Customizing settings for the Data Basis and for the Consolidation Area in which you want to use the hierarchy. You have created a Source Data Basis and entered it in the data basis. In the source data basis you have entered the InfoObject catalog containing the InfoObjects to be loaded.

If you use Load from Data Stream: the InfoObjects or virtual InfoObjects that supply the source hierarchy are already in SAP NetWeaver Business Intelligence (BI).

If you use Flexible Upload: you have created the files to be uploaded in the sender system.

Procedure

Visualize the internal structures for the source hierarchy and the target hierarchy. Formulate mapping that is suitable for creating redundant entries in the target hierarchy on the edges on which you want to summarize.

In the consolidation workbench, create a data collection method and define mapping. For additional information on Customizing, see Customizing for Flexible Upload or Customizing for Load from Data Stream .

Execute the method in the consolidation workbench.

Result

You have uploaded the source hierarchy to the consolidation system. The system has created the target hierarchy, and summarized it based on the specifications in mapping.

Example

The example illustrates how mapping can be used for:

Aggregation when loading a profit center hierarchy

Assignment when loading the related profit center master data