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

Process Chain Problem

Hi,

We have an ODS and an InfoCube. After the data is loaded into ODS, using the datamart of the ODS will feed the InfoCube. Everytime we feed InfoCube need to dump the InfoCube and reload it, so it is a full update not a delta.

In the process chain, after it finishes the load of ODS it kicks of delta load of InfoCube. I tried to split the both load in two different process chains but still it loads the delta load to the INfoCube. Any Ideas on how to load the full update into InfoCube. In the process chain to the load the InfoCube data, I am using the full update's InfoPackage only. In my opinion for some reason, further processing of the ODS is starting the delta load to InfoCube.

Any ideas how to fix the problem.

Thanks in advance,

GSM.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 12, 2005 at 02:58 PM

    Hi GSM,

    If there is no such process in yr process chain then the only other option will be that you have set the flag for the ODS Automatically Update Data target. Have that reset or remove the process from the process chain and you will achieve yr objective.

    You could also see if there are any active inits for this datamart and delete them. Check if someone has historically scheduled a delta load to the cube.

    Regards,

    Zubin

    Message was edited by: Zubin Limbuvala

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 02:48 PM

    Hi,

    I think the subsequent processing of ODS is triggering the Delta infopackage to the cube.

    You can go and remove the option "Update data targets from ODS object automatically" in the ODS setting.

    You will also get this option if you got to manage screen of ODS, and from there in the Environment menu select Automatic request processing and change the setting of subsequent data load.

    Hope this helps you to avoid the problem.

    Thanks

    Prashant

    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.