Skip to Content

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

loading data


i have a question.

in BI 7. i need to load data from tods in staging layer to write optimize dso in application layer. (one layer to another layer)

please help to complet this task,


Former Member replied

You need to create a datamart to get the data out of your DSO and then update rules against the datamart from your target.

Right click on your tods and choose generate export datasource. This will create your datamart and it will be named 8<name of your tods>. So, if your tods is ZTEST, then your datamart will be 8ZTEST.

Next you need to go to your target and create update rules for your datamart. Right click and create update rules.

Go to your infosources tab and find your datamart. Create an infopackage as usual to load data to your target.

I am currently in a 3.3 system, so some of the terminology may have changed. But this should be close enough to get you what you need.


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