Skip to Content
author's profile photo Former Member
Former Member

Updating ODS Object Data

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2006 at 10:08 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2006 at 10:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2006 at 10:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2006 at 10:49 AM

    Haukur,

    Does the above mentioned procedure help??

    Was waiting for ur reply.

    Regards,

    Marc.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2006 at 02:32 PM

    Great !!

    Really happy that it did work!!

    Thanks,

    Marc.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.