Multi Action - Dynamically derive period for Data Lock step

[PS_1978]

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

[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.