Steps for loading data in ODS

[Former Member]

Hi

I am working on BW 3.5, I need to load data from a table into an ODS. tables are in the BW system the Update rule is also active. Now I need to know what will be the steps to load data into ODS

Thanks in advence

[Former Member · Accepted solution]

The standard data loading steps would be like this..

1. Create a InfoSource in BW.

2. Assign a DataSource (based on the table from which you want to extract the data into BW) to the InfoSource.

3. Create an Update Rule to InfoProvider mapping it with the InfoSource created in step 1.

4. Create an InfoPackage to the InfoSource and trigger the data loads.

or Once your update rules are active.. Go in tab Infosource.. There you find out your Infosource..

Right click on that n Create InfoPackage..Give appropriate description n say Ok..

Now in InfoPackage you can see various tabs.. Give selection ranges in Data Selection tab if required..

else Go in tab Schedule click on Start data load immediately n click on button Start..

It will now pull the data in your ODS.. After that you can check data in your ODS..

The next step is to go InfoSources and find your InfoProvider.

When you find the InfoProvider you'll need to create a InfoPackage to load your data.

Hope it helps

Regards

gaurav

[Former Member]

thanks for the response

[Former Member]

Hi,

The steps would be as follows:

1. Goto RSO2 in BW system and create a datasource based on the table.

2. Now goto RSA1 and create the infosource -> transfer rules and communtion structure and activate.

3. Now goto the ODS -> right click and create the update rule using the infosource as the template.

4. Now create the infopackage and you can load it to the ODS.

Bye

Dinesh