cancel
Showing results for 
Search instead for 
Did you mean: 

Delta-load from existing ODS

Former Member
0 Kudos

Hello,

I have a chain of ODSs loading data from an existing ODS. From this ODS there are already daily delta load into a cube. I want this daily load to go into my new ODSs as well. The load is done by process chains.

From what I've read elsewhere, I would expect the load to automatically go into the first of my new ODSs. That didn't happen. I manually run the "init/delta init" load, but still there is no automatic delta load.

1. I believe the reason is the InfoPackage used. It is probably set to update only a single datatarget. But how can I find this InfoPackage? I don't see it in the list of InfoSources in AWB, even if I choose to display generated objects. Is there any way I can access the InfoPackage through the process chain? I am no expert on process chains, but I believe the load is done in the step "Further Processing" for the existing ODS. In the variant I see only the name of the (existing) ODS. I see no InfoPackage. Where is it?

2. How can I run a delta load manually? If I select "Update ODS Data in Data Target", I can only choose between full load, init load and init/delta init. And I've already run an init/delta init.

I'm using BW 3.5.

Regards,

Christoffer

Accepted Solutions (0)

Answers (2)

Answers (2)

pavan_mankineni
Active Participant
0 Kudos

Hi,

if am correct u want to change ur existing data model i,e include a new ODS to ur chain of ODS.

u can find info package in RSA1 -> INFO SOURCE -> find for 8ODS name i,e export generate data source of ur base ODS.

in that under data targets select ur new ODS if it is not there u may have missed creating update rules for new ods create that update rules then u can fing new ODS in data targets tab of info package.

run INIT manually and set delta for both.

since u cant run multiple init with same selections u have to delete previous init request and run new one.

after that u can run deltas through process chains.

assign points if it helps,

thanks,

pavan.

Former Member
0 Kudos

Right click on the step in the process chain that loads that target and select "display variant" and that should take you into the relevant infopackage.

You could also drill down from the datatarget in RSA1 and you will get to the infopackage that way. Though i think this may be a version 7 feature.

Former Member
0 Kudos

As I have written, I've already done this. (Right click on "Further processing", selecting "Maintain variant".) But in the object list of the variant I only see the ODS object itself. No InfoPackage.

Edited by: Christoffer Owe on Apr 9, 2008 11:40 AM