cancel
Showing results for 
Search instead for 
Did you mean: 

Updating ODS Object Data

Former Member
0 Kudos

Hi,

I'm having a situation where I have a ds->ods->cube and I use process chain to load data from source system into ods and activate ods data. I also update data targets from the process chain. The infopackage for loading data into the ods is not delta and I want to get the data without delta all the way into the cube - request by request. The update process seems to select either "init" or "delta" (generated) infopackage assosiated with the ODS export datasource. I can't find the way to do this using process chain and force it to select the "full" infopackage. Does anyone know how to do this in automatic process?

Best regards,

Haukur

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Haukur,

As the msg says the infopackage is generated by the system.this cannot be included in the Process chain.

please create one more infopackge, mark it to full and include this infopackage in the chain.

please let me know if it works out.

Regards,

Marc.

Answers (4)

Answers (4)

Former Member
0 Kudos

Great !!

Really happy that it did work!!

Thanks,

Marc.

Former Member
0 Kudos

Haukur,

Does the above mentioned procedure help??

Was waiting for ur reply.

Regards,

Marc.

Former Member
0 Kudos

Haukur,

Hope Marc answer should work. Please update the thread. create new IP, change the load variant for Process Chain using new IP. It should reslove your problem.

All the best.

Regards,

Nagesh Ganisetti.

Former Member
0 Kudos

Hi Nagesh/Mark

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Nagesh/Mark

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Nagesh/Mark

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Nagesh/Mark

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Nagesh/Mark

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Marc,

This seems to work - thank you for your effort.

Best regards,

Haukur

Former Member
0 Kudos

Hi Haukur,

Try this. RSA1 -> ODS -> right click -> Update data Target with ODS data. This would give you 2 options full and init. Select the full option and load.

Bye

Dinesh

Former Member
0 Kudos

Great! it sloved your problem.

Nagesh Ganisetti.

Former Member
0 Kudos

Hi Haukur,

Is it that the option in the infopackage for full update is disabled? The system automatically generates packages once u start updating data from ODS to Cube automatically.These packages do not allow u to change the update option to full.However I think a full infopackage is also created.If not just go ahead and create one.U can include this in the process chain later.

The typical structure of the chain should be:

Start-full load from DS to ODS-activate ODS---full load from ODS to Cube.

Regards,

Marc.

Former Member
0 Kudos

Hi Marc,

Thank you for your prompt reply. It also generates "full" infopackage but when I try to include that in a process chain I get an error saying:

"InfoPackage ZPAK_EY089O8QLC0ABALHAA5P4B7XY is generated; NOT able to be used as loading variant"

Regards,

Haukur