Rules help

[jo_hen]

Is it possible to include a subset name in a rule? The bold part in the rule below is the version dimension, which doesn't exist in this cube. However, I want to feed the annual budget from the latest version in the budget model cube, which is under the subset name "Current Version". Can I replace the actual version with the subset name? I've looked in the rules and reference guides and can't see anything. If not is there another way, other than having the version dimension in my cube (which I'd rather not do?). I know I can amend the rule each time a new version is created, which isn't very often, but would be so much simpler if it can just pick up the subset name.

['Annual Budget']=N:DB('Budget Model','TM1 PPB',!Year,'2011/12 to 2014/15 Budget 310312',!Cost Centre,!Nominal,'Latest Approved Estimates');

Thanks in advance!

[dan.kelleher]

Hi Jo,

You can store the current version in a 'metadata' cube as a text field, or as a text attribute on a 'metadata' dimension and reference the value in your rule. When you create a new version, you also need to update the current version value either manually, or via a TI process.

As an attribute of a dimension called 'Metadata' with 1 element called '1' and an attribute called 'Current Version':

['Annual Budget']=N:DB('Budget Model','TM1 PPB',!Year, ATTRS('Metadata', '1', 'Current Version') , !Cost Centre,!Nominal,'Latest Approved Estimates');

[jo_hen]

That's worked great, thanks Dan.