Does anyone know if you can reference a substitution variable from within a Maxl script? I would like to update a security filter based on changing period and year sub variables. This will allow me to fully automate a filter on top of our planning cube that will prevent users from overwriting actualized months of the forecast if accessing the cube via Essbase connection and adhoc analysis.
This is what I would like to do with the sub vars:
Create or Replace Filter sample.basic.testwrit read on '&FcstYear, Forecast, Working, Jan:&ActMnth', write on '&FcstYear, Forecast, Working, &FcstMnth:Dec'
Grant filter sample.basic.testwrit to Forecast_User_group;