TM1 Forum

Hi Guys,

I have an existing Drill Assignment Rules in which Drill Rules are indicated for each measure I put in that rules.
Here's the sample.

['line void amount']=S:IF((dimix('report month',subst(!period,1,3))<=12 % subst(!period,3,1)@='/') & ellev('period',!period)<=1 & ellev('site',!site)<=2 & ellev('ebr_employees',!ebr_employees)<=1,'ebr','');
['line void count']=S:IF((dimix('report month',subst(!period,1,3))<=12 % subst(!period,3,1)@='/') & ellev('period',!period)<=1 & ellev('site',!site)<=2 & ellev('ebr_employees',!ebr_employees)<=1,'ebr','');
['void txn amount']=S:IF((dimix('report month',subst(!period,1,3))<=12 % subst(!period,3,1)@='/') & ellev('period',!period)<=1 & ellev('site',!site)<=2 & ellev('ebr_employees',!ebr_employees)<=1,'ebr','');

As you can see, the rules for each measure are all the same. I actually have 20 more measures for this rule.

What I want to happen is to have just one line for all of those measures. But my measure dimension also contains rule-based measures that I want to exclude in drill troufh function.

I am imagining, I can just put

[]=S:IF((dimix('report month',subst(!period,1,3))<=12 % subst(!period,3,1)@='/') & ellev('period',!period)<=1 & ellev('site',!site)<=2 & ellev('ebr_employees',!ebr_employees)<=1,'ebr','');

But this rule will work for rule-based measures. CellIsupdatable can be used but if I do, this will exclude consolidated elements for TI-uploaded measures.

Is there other solution for this?

Thanks in advance.

Bunch

Hi Bunch

The easiest would be to use [] while you insert an IF test to look at a particular attribute: to know if you want to drill or not.
So use a Text attribute (for example, "Drill-through measure") using Y/N and the Attrs function will read that value Y/N.
I imagine this list of drillable measures to be quite static so a Text attribute will be fine.

Yes Sir,

I have thought of this one. Although with this, the text attribute should be maintained if ever new measures will be added. But yes this one is the best solution I guess.

Thank you Sir Wim.

Bunch

bunchukokoy wrote:Yes Sir,

I have thought of this one. Although with this, the text attribute should be maintained if ever new measures will be added. But yes this one is the best solution I guess.

Thank you Sir Wim.

Bunch

You could present an Excel spreadsheet or Websheet to update the attribute.
Don't think that maintaining drill rules will be as easy...