TM1 Forum

Hi,

I am building an employee budget setting model in TM1 10.1.1 and am trying to make my dimension updates as dynamic as possible.

One of the dimensions, Pay Scales, includes a picklist cube which allows users to pick a Scale Code, for example, teachers and then return only the grades within that group. i.e. a cascading picklist. This is done by referring to a subset which includes all leaf elements under the relevant Scale Code.

The logic for this is included within the rule for the picklist cube and the first few lines are shown below:

['Current Grade']=S:

If(DB('Staffing-Budget-Setting',!Employee,!Job Number,!Cost Centre,!Detail Code,!Year,!Versions,'Scale Code')@='SC_NJC',
'Subset:Pay Scales:SC_NJC',

IF

(DB('Staffing-Budget-Setting',!Employee,!Job Number,!Cost Centre,!Detail Code,!Year,!Versions,'Scale Code')@='SC_A4C',
'Subset:Pay Scales:SC_A4C',

etc,

etc,
etc))))

My question is, how do I make this dynamic if new Scale Codes are added? Can I automatically update the rule file using a TI process if new Scale Codes appear?

I was thinking that I could include this as part of the process which updates the Pay Scales dimension.

If not do I have to manually update the rules?

Try this approach:
It's much faster (due to having only one IF statement - and even that one is not really needed) and open to any future expansions of Scale Code.

Thanks for the reply.

We are currently undergoing user testing and while this is going on I am updating my documentation and looking at where I can improve the model.

I will look at your solution once this testing is over and update the thread.

Hi Kamil,

have updated my rule with your code and this appears to work!

So big thanks for that.

Just wish I had thought of it!

regards, Mark