企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1441|回复: 3

Exclude rule-based measures in Drill Assigment Rule

[复制链接]

93

主题

423

帖子

630

积分

高级会员

Rank: 4

积分
630
QQ
发表于 2014-3-17 10:24:25 | 显示全部楼层 |阅读模式
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
回复

使用道具 举报

77

主题

412

帖子

590

积分

高级会员

Rank: 4

积分
590
QQ
发表于 2014-3-17 11:43:54 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-17 13:57:55 | 显示全部楼层
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
回复 支持 反对

使用道具 举报

81

主题

411

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-17 14:04:56 | 显示全部楼层
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...

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-7-6 03:00 , Processed in 0.189100 second(s), 17 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表