Multi Action - Dynamically derive period for Data Lock step

[#1]

Hello Gurus - I have a multi action that is being called in Calendar Event. This multi action would extract the data from S4 and loads into SAC Dimensions and Models. While loading the data into models, I am unlocking all periods and locking them back once the loads are completed. However, this is locking the forecast period which is causing issues with Planning.

Any input on passing forecast period dynamically to "Data Locking Step" in multi action? I have forecast starting and ending months in a dimension with member id WKFCSTDEF and properties StartMonth and EndMonth. Please do remember, this multi action is called from Calendar event as daily job.

Any other alternate approach is also fine with me. I want to unlock forecast period after daily loads.

Thanks,

PS

[William_Yu1 · Accepted solution]

I would suggest to check if it's possible to extract data from s/4 into a different version from the one used in planning. 

[PS_1978 · Accepted solution]

Thanks @William_Yu1 - This would do. Regards, Phani

[N1kh1l]

@PS_1978 

The only way I see is that you hard code the forecast periods in Data lock and unlock steps of the multi action. Currently its not possible to set parameters using attributes of a dimension.

Nikhil

[PS_1978]

Thanks @N1kh1l - This would not workout in my scenario as the forecast period is not constant and it changes every quarter. Thanks, Phani

[PS_1978]

Thanks @N1kh1l - This would not workout in my scenario as the forecast period is not constant and it changes every quarter.Thanks, Phani

[zee_siddique15]

Hi N1kh1l,

I am thinking to use your suggestion for my scenario, do you think it is possible?

1) I get Actuals from BW in public. Actual version first, then I use the Forecast "Act Start Week" and Actuals End Week" to understand how many weeks of Actuals need to be copied from "public. Actual" to "public.FM_202403" via the data action.

2) Because I want to see both the Actuals and Forecast data in one line, hence both Actuals and Forecast is sharing the same intersection, I do not use the Forecast Layout here

3) I have an input layout that has Restricted measures to accept Qty and Price restricted to AD_INV_INP at Farm "#" which is the only interface available for users to input the data. i want to just lock the Actuals period on this input layout to not allow the users input at AD_INV_INP but later when they run the data action, I want it to open the Actuals and then copy the latest Actual against AD = AD_INV_STOCK or AD_INV_STOCK_VAL.

[Savio_Dmello]

You can Create a calculated variable in the model based on your WKFCSTDEF dimension that fetches the StartMonth and EndMonth dynamically. This variable should extract the correct forecast start and end dates for each run of the multi-action.

Use advanced Formula that fetches the StartMonth and EndMonth from your WKFCSTDEF dimension into variables. This advanced formula can then create a time range dynamically, and In the multi-action, create a step to unlock the periods dynamically based on the startMonth and endMonth values from the advanced formula.