Solved : Processing date needs to be set before launching the Session Options

[Sanjeev]

Hello ,

I have a requirement where my Uproc U1 whose processing date should be 1st of previous month
EX: If I am launching that Uproc today , the Processing date of that UPROC should be 1st January 2010.
Again the UPROC U1 depends on two other UPROCS U2 (Processing date -1)& U3 (same Processing date ).
So as per our example , the U1 running for Processing date 01/01/2010 should depend on U2 for 12/31/2009 & U3 for 01/01/2010.

I thoguht of incorporating the logic for changing the processing date in the internal script of U1 , but the problem is that the U1 is depending on the U2 (for current date -1 i.e., 02/03/2010) and U1 (for the current date 02/04/2010) which is not as per my requirement.

Is there any way how I can incorporate this logic in U_ANTE_UPROC only for this specific Uproc , i.e., in case of only this Uproc , the above logic for processing date should happen , else no.
Please suggest me if there is any other solution .

[men]

Hello Sanjeev,

What is your exact need? Why would you need to change the processing date ?

Michel

[Sanjeev]

Actually the UPROCS embedded in a session will be invoking BODI (an ETL like Informatica) job which has to run on 1st of every month to process the records (table) of the whole last month. So what I have to do is , I have to set the processing date to last of the previous month so that it can process for the whole previous month .

[men]

Hi,

If your Uproc is defined with functional period "Day", you should be able to define an offset in the processing date in the Task that is scheduled on the 1st day of the month: Set it to "Previous calendar day" (see the "functional data" tab in the Task).

Test it but this should do the trick

Michel