cancel
Showing results for 
Search instead for 
Did you mean: 

Question on Delta capability for ODS

Former Member
0 Kudos

We only have InfoCubes in our system and they are delta enabled. Everything working great.

We now created our first ODS and have been doing full loads from setup table to it. We are now ready to start our delta loads. I saw note 689964 which says to run program RSSM_SET_REPAIR_FULL_FLAG for ODS that has full requests loaded to it and then you want a delta.

My question is that the note says if you activated data you can't run this program (at least that's how I read it). We have all our requests activated in the ODS.

Please confirm if it's possible to start a delta. Confirm the below steps:

1. Run this program in BW.

2. When this program finishes run the Init Delta without data transfer.

3. Run the delta.

Will the above work?

Also, does the init delta read from delta queue or setup table? I see conflicting results on SDN. Where does the init delta without data transfer read.

Do you schedule the V3 job in R/3 before the delta init or delta init without initialization?

I thank you very much.

Cheers

Mike

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Mike,

What Edan said is true for not delta eabled datasource: always full upload to ODS and then delta to cube.

What was said by Stephan is true for delta enabled DS (it looks like your case).

And there is a talk about different delta. In first case it's init of delta channel between ODS and a cube. In the latter - about init delta for datasource - ODS channel.

Best regards,

Eugene

Message was edited by: Eugene Khusainov

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Mike,

you have to run the program of step 1, otherwise you cannot activate the Init Delta in your ODS.

The delta will not read from setup tables (logistics area, other I do not really know) but from BW delta queue (RSA7). The V3 job will fill this BW delta from the logistics delta queue.

So you have to schedule the V3 job once before the init to clear the logistics queue, afterwards SAP recomends to schedule it every hour. The BW Delta will get no data if the V3 job has not run before.

Regards

Stephan

Former Member
0 Kudos

Hi

from my experiance you can skip 1

and just go 2. and 3. no problem.

Reg's

Edan

Former Member
0 Kudos

Hi Edan,

So you've done this before? STep 2, then 3 above.

What about the delta and delta init...where does each one read from? Read from delta queue I assume, not setup tables.

Former Member
0 Kudos

yes

the ODS will track its changes automatcly once you start the delta by running an init.