Loading Master data in BI

[Former Member]

hi,

I am new to BI 7.0 i loaded the relevant Business content and i want to load the master data for SD Module.

Please tell me the procedure of how to load master data in BI 7.0 Data source.

Regards,

Shahid

[chemicala_srimallikarjuna]

Hi ,

For the majority of Master Data, there will be datasources in Business Content. Have you installed any Business Content as yet? 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

If you need a detailed step by step procedure of SD data extraction:

this document should help you

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

There is one more interesting wiki which also mentions some of the standard datasrces in sales:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/main&;

Hope this helps,

regards

CSM Reddy

[Former Member]

Hi Shahid,

If you have worked with BW 3.5 you maybe already have seen that in BW 7.0 there is a different concept about data loading. Common 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.

Hope this information will be useful for you:)

Marin