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

[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