Master data transport steps

[Former Member]

Hi expert,

What will be the steps to transport master data in BI 7? I have transported relevant R/3 data source and then replicated data source in BW. Then I start collecting BW info objects for the master data. When collecting BW info objects for transport, do I need include data source, transfer rule and info pacakges? If so, why do I need to collect data source again in BW system as it has already been replicated from the source system?

Thank in advance for any advise.

Sharon

[chemicala_srimallikarjuna · Accepted solution]

Hi,

The procedure for loading master data in 7.0 is :

1. Create / Activate your data source for the info object you want load - for example data source for attributes, text ot hierarchy - SAP R/3

2. Replicate data source in SAP BW

3. Create Data Transformation ( similar to Update and Transfer rules) between Data Source and Info Object

4. Create DTP ( data transfer process) to maintain the data flow . Here you have to specify that data comes from Data Source and goes to the Info Object.

5. Create an Info Package on the Data Source and load data - !!! have in mind that this will load data only into PSA table

6. Final step - you have to start your DTP - this will load data from PSA to the Info Object.

For the majority of Master Data, there will be datasources in Business Content. need to install Business Content . This will install all datasources that you require - Customer, Material etc. plus all standard config - DSO, Cubes etc.

http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a66d5e07211d2acb80000e829fbfe/frameset.htm

Pls Check the following threads for DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fbd598481e1a61e10000000a422035/frameset.htm

Hope this helps,

Regards

CSM Reddy

[Former Member · Accepted solution]

Hi sharon,

Dont transport master data different Infoproviders different.

That is very tedious process.

If your are transporting standard cubes...Pls see the following steps....

1.Source system assignment.

2.Conversion(Source system ....Target system)

3.Grouping data flow BEFORE

4.Collection mode AUTOMATICALLY

5.display LIST

6.Drag and drop your Infoprovider.(Check infocube objects are selected properly or not...by default it will check

all the related objects)

7.Click on package...

Note:Check all infoobjects.....by default it will check some objects only....

This is the best way for transportation.

If you feel good information pls assign the points.

Thanks & Regards,

Praveen.K

[Former Member · Accepted solution]

Hi Praveen,

Are you saying if I have a new info provider like ODS that i need to transport, I don't need to transport the master data first? I can just include everything in one big transport from transport connection and transport them all together?

Sharon

[Former Member · Accepted solution]

Hi Sharon,

Yes transport all in one request.

If you have BEx Queries transport other request.

Thanks & Regards,

Praveen.K

[Former Member]

yes.. u have to collet all these..

the data source structure should be created in the bw side, where in the fields from R/3 are replicated.

so in this case, you have to include all of the said elements while transporting