Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Steps for loading data in ODS

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
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question