Delta update for ZWM_O03 is invalidated

[Former Member]

Hi guys,

daily delta is loading from ODS to two data target (ODS, CUBE).

today it has stuck up and it showing the error message that " delta upadate for the ODS and cube is invalidated.

when I lokk into the procedure as it shows I must reinitialise the cube and ods.

can any one give me an suggestion for this issue?

Thanks

Ram

[Former Member · Accepted solution]

Hi Ram,

Check if this post helps:

Bye

Dinesh

[Former Member · Accepted solution]

HI,

for ODS1 is full load and then loading into two data target(ODS2 and Cube)

I have deleted one request from ODS1 now it shows that ODS1 is invalidated.

I have seen some threads on this issue , they mentioned that I need to init.

may I know whether I need to init ODS2 and cube .?

since the ODS1 is full load

please urgent

Thanks

Ram

[Former Member · Accepted solution]

hi,

could any suggest please it is urgent.

Thanks

Ram

[Former Member · Accepted solution]

HI Ram,

u r telling that u r running the deltas in first then u r telling the ods is full load

plz tell me the wt exactly u r loading? plz give the query with detail

[srinivas_anilkumar · Accepted solution]

Hi Ram,

If you are sure that the error causing is because of the deletion of the request in ODS1, then delete all the above requests in ODS1 (including the one you deleted) and then run a init w/o data transfer to both cube and ODS2 and then repeat the full load or reconstruct the rest of the requests that you deleted above and run the delta from ODS1 to cube and ODS2

Regards,

Srini

Message was edited by:

Srinivas

[Former Member · Accepted solution]

hi srini,

I followed the same procedure ,since one of my colleague suggested what you have mentined, any have the problem was solved.

Thanks for your valuable suggestion. and assigned full points.

Thanks

ram