企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 469|回复: 5

Please help me..

[复制链接]

76

主题

356

帖子

534

积分

高级会员

Rank: 4

积分
534
QQ
发表于 2014-3-17 17:03:27 | 显示全部楼层 |阅读模式
When I am summing the element values at leaf level(N), if any of the elements are null it is not summing up. Can anyone help me on this.


['After Adj'] =N:['B4 Hedg'] + ['Prior Adj'];
in some cases ['Prior Adj] is having no values, at that juncture that the result is yeilding null/0. Actually it should yeild the value of ['B4 Hedge'] in the cell ['After Adj']
回复

使用道具 举报

80

主题

407

帖子

591

积分

高级会员

Rank: 4

积分
591
QQ
发表于 2014-3-17 19:26:01 | 显示全部楼层
Any reason you're not using a hierarchy for this instead of rules?

Steve
回复 支持 反对

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-17 20:12:20 | 显示全部楼层
Just like Steve I'm wondering whether there's anything stopping you from using a consolidated element instead of the sum in the rule.

Are you using SKIPCHECK/FEEDERS? If so, what is the feeder for the rule? Could it be you're feeding from ['Prior Adjustment'] only?
Is the ['Prior Adjustment'] element in itself a rule calculated element? If so, what is the calculation (and feeder) for this element?

Michel
回复 支持 反对

使用道具 举报

76

主题

396

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-3-17 20:30:27 | 显示全部楼层
ThanQ Michel, it worked when I have included elements in @ Feeders.
回复 支持 反对

使用道具 举报

64

主题

354

帖子

512

积分

高级会员

Rank: 4

积分
512
QQ
发表于 2014-3-17 20:45:16 | 显示全部楼层
As pointed out by both Steve and Michel you'd be better to do this using a consolidation in the dimension instead of a rule.  It's faster, clearer and will apply automatically to any cube that uses the dimension.

Martin
回复 支持 反对

使用道具 举报

75

主题

398

帖子

573

积分

高级会员

Rank: 4

积分
573
QQ
发表于 2014-3-17 21:48:03 | 显示全部楼层
ram3sh wrote:ThanQ Michel, it worked when I have included elements in @ Feeders.

It may work, but rules are considerably less efficient than consolidations. You should always opt for the latter if you have a choice.

{Edit: Martin beat me to it by a minute, but I'll leave this post here for emphasis.}
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-7-2 18:17 , Processed in 0.241650 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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