Process Chain Problem

[Former Member]

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.

[former_member1382010 · Accepted solution]

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

[Former Member · Accepted solution]

Zubin,

Thanks for your reply. Yes, we did load init load for that. I will try to delete and re do it. Will let u know.

Thanks,

GSM.

[Former Member · Accepted solution]

Zubia,

I did delete the init load request. Then even I deleted the INIT & Delta InfoPackages too. But still it is starting delta load into the InfoCube.

Any Ideas ?

GSM.

[Former Member · Accepted solution]

Hello,

Why do you want to regularly do full uploads to the InfoCube? One of the reasons why an ODS exists is to upload only delta into a Cube!

Remove the Update data target step and instead introduce a Load InfoPackage step. The variant will be the Full Update InfoPackage that exists on the export datasource.

To find the InfoPack, go to the ODS, right click and select update data targets. In the next screen take the InfoPack technical name and insert this into the process chain.

Cheers

Aneesh

[former_member1382010 · Accepted solution]

Hi GSM,

When the delta loads into the cube, try to see which is the infopackage which is loading it

Go to the infopackage and check if there is any background scheduling for that infopackage or whether that infopackage exists in an old chain which has been activated.

Let me know how you get along.

Regards,

Zubin

[former_member188975 · Accepted solution]

Hi GSM,

In your InfoPackage, go to menu Scheduler > Initialization options for Source System. If you see an entry here, this means that an initialization has been performed for this datasource. Please delete this row by selecting and clicking on the trash can. Then the deltas should not be loaded to your cube.

Hope this helps...

[Former Member · Accepted solution]

Zubia,

I did checked for any released jobs/scheduled jobs for the process chain. None exists.

System is generating new Init and Delta packages at runtime. Even If I delete them it recreates it.

Thanks,

GSM.

[Former Member · Accepted solution]

Bhanu,

I already deleted the init loads from initialazation loads from source system. At runtime system is generating the delta & init Infopackages and loading deltas.

Thanks

GSM.

[Former Member · Accepted solution]

Hi,

Now I didn't delete the system generated init & delta Infopackages. I only deleted the init request. It deleted contents of the cube and loaded full upload. Also added init request on top of it. Now again if I run the load it runs the delta.

Is there any way to get rid of the further update process from process chain ?

Thanks all,

GSM.

[Former Member · Accepted solution]

Hi gurus,

When I did maintain of export datasource, datamart's delta is checked. I cannot uncheck this. Is there a way to get rid of the delta ?

I appreciate your help,

Thanks,

GSM.

[Former Member · Accepted solution]

Hi dear,

but have you deleted your init from the scheduler (Initialization options for Source System) of your 8* infosource (in datamart) ?

[Former Member · Accepted solution]

Roberto,

In my replies I did say that I did delete the init requests of the datamart.

Deleted init from the scheduler of my 8* infosource. If you display 8*Infosource, can see Delta check box to be checked. System doesn't allows to change that.

After deleting the init request, process chain is loading full update but also initiating the init and creating new init request. SO everytime I have to delete this request.

If that is the case we cannot automate the load with process chain.

Any ideas ??

Thanks,

GSM.

[Former Member · Accepted solution]

If in your process chain you use IP with full mode, I think that PC is not the problem (do you see that PC use some IP different than the one you insert in the customizing process ? I don't think so..), but an automatic update coming from your ODS...open an OSS support request in order to verify if there is some inconsistencies in your ODS settings...

Bye,

Roberto

[former_member188975 · Accepted solution]

Hi GSM,

I assume that you are using the process: Update ODS Object Data Further Update in your process chain. You can take this out and load using an InfoPackage that loads Full data from the ODS to the cube. This should may be fix the issue, without having to bother about the Init.

Hope this helps...

[Former Member · Accepted solution]

Bhanu,

If I delete Update ODS Object Data Further Update from the process chain then, when you check on the process chain it raises warning saying Further Update process must be a preceding process.

Thanks,

GSM.

[former_member188975 · Accepted solution]

Usually these warnings are not a problem and in big process chains there are sometimes lots of them. Go ahead and try to run it and see if it gives you the desired result.

[Former Member · Accepted solution]

Removed the subsequent processing from process chain, ignored the warnings. It works fine now.

Thanks all,

GSM.

[Former Member]

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

[Former Member]

Prashant,

On the ODS only set quality status automatically only checked. Update subsequently to DataTargets is not checked.

SO any ideas,

Thanks,

GSM