delta error in ods

[Former Member]

hi experts,

if delta load fails b/n ods &infocube

how to rectify that , for that what is the procedure

when we are loading the data ods to infocube how to choose the

keyfields?is it equal to dimensions

thanks in advance

venu

[Former Member]

Hi,

It's the same procedure which we follow for the delta from R/3 to the Bw targets.

The only thing is if you can correct it in the PSA then you can correct it there and then load it from there.

Or you can delete the failed delta request from the cube and relaod the delta

it will give you warning that you are repeating the delta.the new delta will bring the records from the failed delta as well as the records from the new delta if any.

Th key fields of the ODS are not equivalent to dimension.

Dimension are for the logical groupings of the objects and are decided in such a way that the size of dimension table should bve as small as possible.

Where as the key fields of the ODS are like the keys of the table if you want to identify a particular value with respect to a char or combination of char.just imagine it as a table with keys.

hope it clears

Thanks

[Former Member]

hi,

if the delat load fails then the rewuest will becoem red so when next time the delta is extracted it will ask whweter u want the previous delta load again.

from ods to infocube u can have the key fiels in the same dimension.

regards.