ODS to cube in process chain

[Former Member]

I am loading data to an ODS and then from the ODS to the cube. I can do this manually by saying "update ods data in data targets" but how can I do this in a process chain? I can figure it out till the ODS part but not from the ODS to the Cube. Thanks.

[former_member188975 · Accepted solution]

Hi Uday,

You can either use the process Update ODS Object Data (Further Update) or simply Execute InfoPackage and use the Infopackage that loads from ODS to Cube.

Hope this helps...

[Former Member]

Hi

Check out the link to create the Process chain

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/b0afcd90-0201-0010-b297-918...

Thanks=Points in SDN

SANJEEV KUMAR HAMSALA

[Former Member]

Hi,

There is a process type called further update that you can use for the same. Else just repeat the same steps you did for loading to the ODS. Only difference will be instead of the ODS, you'll have the cube in there and the source will be the ODS.

But make sure that even if you use further update or repeat the steps for the load to ODS, those steps have to come after the data has been loaded and activated in the ODS. Also make sure you have checks to load the only if the ODS load and subsequent activation are successful.

Cheers,

Kedar

[Former Member]

If in ODS properties you mark flag for automatically update data targets, it is done automatically always that a new load come to the ODS.

If you can do it "manually" in a process chain, look into infosources --> not assigned nodes --> DM --> 8<your ODS>. Create a infopackage type delta and add it to a process chain.

[Former Member]

Oscar, if I mark it in ODS settings to update data targets, will it treat it as delta? Also, I cannot find it under infosources. Are there any additional steps that I may be missing?

[former_member188975]

if I mark it in ODS settings to update data targets, will it treat it as delta? YES

I cannot find it under infosources: In the RSA1 screen > menu Settings > Display generated objects > Show generated ODS objects.

Hope this helps...

[Former Member]

"if I mark it in ODS settings to update data targets, will it treat it as delta?" YES.

Infosources --> Not asigned nodes --> DM

In this path should be all ODS that are infosources, usually named as 8<Your ODS>. If you don't see it there try to refresh or menu settings --> display generated objects

[Former Member]

Ok, got it. Thanks all. I shall award the points. One more clarification needed. When I say update data target from the ODS context menu, it's generating the data source and info packages for full and init updates, right?

[Former Member]

Hi,

You need to drag the already created infopackages in the process chain. The process chain itself will not generate the infopackages.

Cheers,

Kedar

[Former Member]

I wasn't talking about the process chain. I was asking how the info packages get created. Is it when the ODS is generated?

[Former Member]

If ODS is infosource it is placed in the path comented before.

Every time you update data target from ODS via context menu the corresponding infopackage is created and placed there

[Former Member]

Hi,

It can happen in either of the 2 ways. If you directly update the data by right clicking and updating the data target, then they get created automatically.

But if you have the export datasource already present then you have to right click on the infosource and then create your own data package.

You can try out these things in a sandbox client and things would be much clearer.

Cheers,

Kedar