Explain the steps to load master data hierarchies from R/3 system.

by: Reddy

A summary of the steps are as follows:

1) Goto Hierachy tab in infobject on to which your loading Hierachy data.

2) Select With Hierarchies.

3) Select Hierarchy Properties ( Time Dependent or not time depen..etc..)

4) Click on External Chars in Hierarchies, in that select the characterstics on which this Hierarchy is depending.

5) Then Create Infosource, assign Datasource.

6) Create Infopackage, to load Hierarchies.

7) Hierarchy section tab in Infoapackage select load Hierarchy and refersh the Available Hierarchies from OLTP, If it is Time dependent select time interval in update  tab.

8) Then start the load.

If you want to load from Flat file, some what different way to do it.

It is normally done by the following: 

Transferring the master datasources in RSA5 to RSA6 and then replicating the DS into BW and assignment of DS to Infosource and cretaion of Infopackage and load it into the master tables.

Generally, the control parameters for data transfer from a source system are maintained in extractor customizing. In extractor customizing, you can access the corresponding source system in the source system tree of the SAP BW Administrator Workbench by using the context menu.

To display or change the settings for data transfer at source system level, choose Business Information Warehouse --> General Settings --> Maintaining Control Parameters for Data Transfer.

Note: The values for the data transfer are not hard limitations. It depends on the DataSource if these limits can be followed.
In the SAP BW Scheduler, you can determine the control parameters for data transfer for individual DataSources. You can determine the size of the data packet, the number of parallel processes for data transfer and the frequency with which the status IDocs are sent, for every possible update method for a DataSource.

To do so, choose Scheduler --> DataSource --> Default Settings for Data transfer.

In this way you can, for example, update transaction data in larger data packets in the PSA. If you want to update master data in dialog mode, smaller packets ensure faster processing.

Information about InfoCube Compression
Infocube Compression

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com