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,
Brian Anthony 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.