TM1 Forum

HI
i have a period Dimention. Year-> Quarter -> Month . Now we are entering exchange rates for every month. So I want to lock previous month dynamicly.
Manuly i am able to do it now by 'Lock' Security. Am locking every element. But how can i do it dynamicly...

plz helpp

You can write a TI Process to setup the security. You will have to use the ElementSecurityPut() and SecurityRefresh functions.

Then you can either run the Process manually or can put it within a Chore which runs automatically every month.

Thank you very much and also can you tell me how this works
Okay ElementSecurity is good .. Can you tell me if i need to put element security to a subset of Current Year

Subset: Current Year --> Dynamic with MDX query.

This subset contain example: 01-2010,02-2010.............. 12-2010
So this always contain 12 elements updated every year automatically.

Now comes Function ElementSecurityPut(Level, DimName, ElName, Group);

Here level = Lock , DimName = Period , Elname= ????? and Group = abc1

How to use my subset and tell his function to lock only the previous months .For example today month is 09-2010 . I need to lock 01,02,03,04,05,06,07,08-2010 and 09-2010....11-2010,12-2010 must be editable.