cancel
Showing results for 
Search instead for 
Did you mean: 

create the process chain

Former Member
0 Kudos

Hi all,

Can someone tell me if my steps are correct for creating the process chain for uploading from ODS into the cube.

Here are steps that I did:

1. created the 'full load' infopackage in the infosource for uploading from the Infosource into the ODS.

2. right click on ODS and select 'update ODS Data in Data Target' to upload into the cube (select 'init load').

3. create another 'full load' infopackage in the infosource and use it to create the process chain by pressing the 'process chain maintenance'.

Thank you.

View Entire Topic
Former Member
0 Kudos

Hi,

if that is the case then u have to replicate ur data sources for ur BW system.

right click on ur BW sosurce system and then select the replicate data sources. later u will find ur data sources.

check it and let me know the details-

Regards-

MM

Former Member
0 Kudos

MM,

I have replicated the datasource in the BW system but I still didn't see the infosource- 8xxxxx? Can you tell me if I need to create one infosource to assign this datasource? Why I still cannot find it?

One more question-- Can I create 'delta load' for the update from the ODS into the Cube right away after I ran the 'init load' if I right click on the 'update ODS to the datatarget'? It seems that I have to do the delta load next day after I created the init load. If I am right, please correct me. I try to clear some doubts. Thank you.

Former Member
0 Kudos

Hi john,

If you dont find the generated datasource, click on Setting-> Display generated Object -> Show generated ODS object in RSA1. This will show all the generated objects.

Yeah you have to create one infosource and then assign this datasource into the infosource.

You can create delta loads from the update from the ODS into the cube. First you run the init and then can create one more IP for delta or you can change the same IP. You need not right click and Update ODS to data targets but you have to schedule the delta IP. First day you run the init and from next day onwards you can run the delta IP in chain.

I hope i have cleared ur doubts.. if so pls assign soe points

Sriram

Former Member
0 Kudos

Hi Sriram,

Thank you for resolving my doubt that the 'init load' and 'delta load' cannot be done in the same day.

Can you also answer me these few qustions?

1. If I have to create one infosource to assign the datasource 8xxxx,then how can I see it in the infosource list when I click on 'show generated ODS object before I create the infosource? Please explain.

2.I did click on Setting-> Display generated Object -> Show generated ODS object in RSA1 but I still cannot see the infosource 8xxxxxx in the list. Why?

3. How can I schedule the delta IP if I don't right click on and select "Update ODS to data targets "? Can you clarifiy it? ( not sure if you mean to select 'generate export datasourc')

4.in you last sentence, you said: run the delta IP in chain; do you maean use the delta IP to create the process chain?

Thank you.

Former Member
0 Kudos

Hi john,

I will try to answer to my level best

1. Sorry if got confused with my previous post.. you cannot see the infosource when you say 'show generated ODS object'. Its for an IP which is used for the infosource with export datasource. Sorry for that. You have to create one new info source and then replicate your already created data source and assign it to the newly created infosource.

2. I think i have answered this question also in the first one.

3. Once you create an infosource, assign this infosource to export datasource (8xxxx), you have to create one IP. Then if you run this ip with init, it will initialise the delta and then you can go for delta. This will take care of loading data to the final data target. So executing this IP is as gud as Update the ODS data to final targets.

4.Yes. I mean use the "Execute infopackage" process type and maintain the delta IP as variant in your process chain. ( this works only if you have successfully run the init IP )

Hope i cleared your doubts.. If anything else, pls post it

Sriram