cancel
Showing results for 
Search instead for 
Did you mean: 

Process Chain Logic

mr_v
Active Contributor
0 Kudos

Hi Experts,

I have a scenario where I have 3 different cubes.e.g. lets say cube 1 holds data for current Month, cube 2 holds data for current year (2007) and cube 3 holds data for Next Year (2008).

Data from DSO daily loads to Current Month Cube, at the end of each month data would be deleted from "Current Month Cube" and dumped to "Current Year Cube (2007)".

In next year 2008, at the end of each month data would be deleted from "Current Month Cube" and dumped to "Next Year Cube (2008)".

For the year 2009, (delete 2007 data and load 2009), and for the year 2010, (delete 2008 data and load 2010).

This process should be automated i.e. which cube to load should be done auto.

Any ideas would be highly appreciated.

Thanks in advance,

V

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You need to have several process chains running each with one data target and a scheduled date to run. You can make use of end of month end of year and other date options but I would be concerned about the followings:

What if a transaction posted with a back date? For example: you received your last transaction for December 31 and that night you promoted the data from all the respective next month and yearly cube but the next day some transaction shows up with posting date of december 30th (or so). The transaction would sit in the ODS and if not checked for exact date to promote would end up in the wrong cube.

Without knowing exactly what kind of data we are dealing with it is hard to give out a fool proof advice. Considering that you already have clean data and there is no chance of back date posting, just create multiple process chains scheduled for each events and deleting the unnecessary data after successful data loads. The only thing is that you must have all those next year's cubes ready before hand.

Let me know if you have certain special condition that you want to share.

Thanks.

Bilal

former_member184494
Active Contributor
0 Kudos

Have this process in a separate process chain triggered on a particular date ( you will find last day of month and year in scheduling options for the process chain start variant...

Arun

Hope it helps...