Advise in process chain design

[Former Member]

Dear Experts,

I have a complex issue here in case of design of a process chain. In our system, data is loaded from R/3 to ODS1 -ODS2-Cube.

The data is loaded to the ODS1 and ODS2 everyday but the data is loaded to cube for every 15 days. There is a program that has to be run before loading the data to cube. The program uses two different kinds of calendars X1 and X2(not both at the same time) and each calendar is one month apart. For example if X1 has Aug 1st as date in it, the next date in X1 would be Sept 1st and the X2 has dates in such a way that the date is Aug 15th and the next date in X2 is Sept.15th. So, as the system uses both the calendars, it uploads data to cube every 15 days.

Now I have to make a process chain in such a way that the data gets loaded into the ODS1 and ODS2 eveyday and for every 15 days to the cube using two different calendars. I made a process chain for loading till ods2 and then two different local chains for loading cube. One calendar is given in each start condition. Now I don't know how to integrate the whole chain!

I appreciate anybody's help or advise. ery much.

Thank you v

[Former Member · Accepted solution]

So what you are saying is there is no system to automatically kick start the jobs / process chains. How are the loads being managed if that is the case, because I am thinking every day there will be so many loads to be done. Doing it manually seems labor intensive.

Just out of my own curiosity.

[Former Member · Accepted solution]

There is a contracting company that does this. they monitor. I don't know about the rest. How they are managed. There are for sure few cahins. Coming to the topic, can u suggest me anything?

Thank you.

[Former Member]

How are the other jobs scheduled in your organization. I am thinking , treat each of these process chains as seperate jobs and schedule them in such a way that the success of PC1 leads to the success of PC2.

In our organization , we use Control M to schedule all the jobs.

[Former Member]

Hai Sudeeptha,

Some of the jobs are done manual and others through process chains. But this scenario is a kind of tricky one. So, Just wondering how to do it.

[Former Member]

Can somebody please help me in this issue?

Thank you very much.

[Former Member]

Visu,

Create one process chain and schedule it to run everyday.

In the initial part put the load to the ODS. Before the load from ODS to InfoCube, put in the program that checks the date is 1st. Put in the second program also and link it to the same predecossor step, i.e. activate ODS.

After this put an OR process that joins the output of these two steps. Next is the load from ODS to InfoCube. If either one of the programs is OK, then the load from ODS to InfoCube will go through.

You can make do with one program also rather than 2.

Aneesh

[Former Member]

Hai Aneesh,

Thanks for the reply. I think we are not in the same page. May be my explcation is not clear. Data is loaded into ODS2 and then a program is run. lets forget the program anyway, it checks for some unwanted records and deletes them. So, soon after my ODS, there are two paths for me, ofcourse both loading the cube but in one path, a program is run and in other the program is not run.Also the start dates of loading are different for these two.If the first part loads data(without running a program) on Aug1st then the second loads data(also runs a program) on 15th to cube.Again the first path has to laod data to cube on 1st of spet.,without running a program and then on 15th sept. the second loads datam with program run. This repeats on and on. I know it very confusing.

This is what I did. I made a separate processc chain PC1 for loading till ODS(runs daily) and then two different chains, PC2 and PC3(runs for every 15 days) with different start conditions(defined by calendars). PC2 is simply loading data to Cube but PC3 has an additional program in it. Now both PC2 and PC3 donot load at the same time. I have to connect PC1, PC2 and PC3. Can I just make a connection like branches and leave it? so that the loading till ods is done every day but the chain stops at the PC2 and PC3 as the start condition is not satisfied and the PC2 and PC3 run only when their date is reached?

Thank you very much.