Loading Hierarchies 

Use

You can load hierarchies from different source systems:

·        From an SAP system

Since the metadata is already delivered, you can directly load the standard hierarchies from an SAP system.

·        From an external system (BAPI, file)

If you want to load hierarchies from an external system, you have to first maintain the metadata for this hierarchy.

Furthermore, you can load hierarchies using the data mart interface from another BW system. See Hierarchies and Using the Data Mart Interface.

Prerequisites

·        In the InfoObject maintenance, the indicator With Hierarchies is set for the hierarchy basic characteristic, meaning that the characteristic can have hierarchies.

·        If you load a hierarchy, you have to have selected the permitted characteristics in the InfoObject maintenance. See Tab Page: Hierarchy in the InfoObject maintenance.

·        To load hierarchies from external systems, you have to edit the metadata in the transfer structure maintenance. See Uploading Hierarchies from Flat Files

Procedure

...

       1.      Select the InfoSource tree under Modeling in the Administrator Workbench.

       2.      Select the InfoSource (with direct update) for the InfoObject, to which you want to load the hierarchy.

       3.      Chose Assign DataSource from the context menu. This takes you to the Assign Source System dialog window.

       4.      Select the source system from which the hierarchy is to be loaded. You get to the InfoSource maintenance.

¡        If the DataSource only supports the transfer method IDoc, then only the transfer structure is displayed (tab page DataSource/Transfer Structure).

¡        If the DataSource also supports transfer method PSA, you can maintain the transfer rules (tab page Transfer Rules).

       5.      Save your entries and go back. You arrive at the InfoSource tree for the Administrator Workbench.

       6.      Choose Create InfoPackage from the context menu (see Maintaining InfoPackages). You arrive at the Create InfoPackage dialog window.

       7.      Enter the description for the InfoPackage. Select the DataSource (data element Hierarchies) you want and confirm.

       8.      On the Tab Page: Hierarchy Selection, select the hierarchy that you want to load into your BW system

Specify if the hierarchy needs to be automatically activated after loading or needs to be noted for activation.

Select an update method (Full Update, Subtree-Insert, Subtree Update).

For more information, see Loading as Subtrees 

If you want to load a hierarchy from an external system with BAPI functionality, make BAPI-specific restrictions, if necessary.

       9.      If you want to load a hierarchy from a flat file, maintain the Tab Page: External Data.

   10.      Maintain the Tab Page: Processing 

   11.      Maintain the Tab Page: Updating

   12.      To schedule the InfoPackage, you have the following options:

(Manually) in the scheduler, see Scheduling InfoPackages

(Automatically) using a process chain (see Loading Hierarchies Using a Process Chain)

When you upload hierarchies, the system carries out a consistency check, making sure that the hierarchy structure is correct. Error messages are logged in the Monitor. You can get technical details about the error and its type and way of removal in the long text for the respective message.

Result

The hierarchy structure and the node texts or intervals are loaded. The structure information and the hierarchy texts are stored in the BW system. You can edit the hierarchy.

In order to be able to use the hierarchy in report, the hierarchy has to be activated. As long as you have not selected the respective indicator for Loading Hierarchy…and Note for Activation or Activate in the InfoPackage, you can also activate the hierarchy later (see Editing Hierarchies).

If there are aggregates for a hierarchy and the hierarchy is noted for activation, it is activated after the next change run.