企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 929|回复: 5

Use middle leaf value for consolidation

[复制链接]

78

主题

397

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-3-20 07:10:25 | 显示全部楼层 |阅读模式
Hi

I wonder if anyone can help me

Rule Editor

['Register']=N:IF(ATTRS('CRL BAR Period',!CRL BAR Period,'Present')@='TODAY',DB('Test1',!Branch,!CRL BAR Period,!CRL BPR Scenario,'Register Available'),STET);

['Register available']=C:If(ELLEV(' BAR PERIOD',!BAR PERIOD)<>0 ,DB('Test1',!CRL Branch,!BAR Period,!Scenario,'Register'),STET);


Dimensions

Bar Period
Scenario
KPI
Branch


What im trying to do is override the consolidation with TODAYS input but leave the other consolidation with the last element in there consolidation.

This is what i would like
Actual
Register Available

SO-----------Year 2011----------------------JAN---DAY 1---DAY 2-----DAY 3---- DAY 4--------FEB--DAY1 --DAY 2----DAY 3-----DAY 4
-------------------12---------------------------10----- 9---------8--------- 4----------10-----------12-------9------12 --------0--------- 0


Hope this make sense, any help would be really appricated

本帖子中包含更多资源

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

x
回复

使用道具 举报

69

主题

365

帖子

518

积分

高级会员

Rank: 4

积分
518
QQ
发表于 2014-3-20 08:33:25 | 显示全部楼层
Hi,

I don't quite follow this. I can see you want to force a rule calculated consolidation but can you be a bit clearer here;
What im trying to do is override the consolidation with TODAYS input but leave the other consolidation with the last element in there consolidation.

and possibly use a screenshot to show what the expected result is.
回复 支持 反对

使用道具 举报

76

主题

356

帖子

534

积分

高级会员

Rank: 4

积分
534
QQ
发表于 2014-3-20 08:34:20 | 显示全部楼层
Ive changed the code a little  please see below

['Register']=n:IF(ATTRN('CRL BAR Period',!CRL BAR Period,'Presentnum')>0,DB('Test1',!CRL Branch,!CRL BAR Period,!CRL BPR Scenario,'Register Available'),DB('Test1',!CRL Branch,ELCOMP('CRL BAR Period',!CRL BAR Period,ELCOMPN('CRL BAR Period',!CRL BAR Period)),!CRL BPR Scenario,'Register Available'));


['Register Available']=C:If(ELLEV('CRL BAR PERIOD',!CRL BAR PERIOD)<>0 & ATTRN('CRL BAR Period',!CRL BAR Period,'Presentnum')>0 ,DB('Test1',!CRL Branch,ELCOMP('CRL BAR Period',!CRL BAR Period,ELCOMPN('CRL BAR Period',!CRL BAR Period)),!CRL BPR Scenario,'Register'),DB('Test1',!CRL Branch,'25/10/2011',!CRL BPR Scenario,'Register'));


if you see on the screen shoot i want Oct -11  to be 6000 but sept -11 to be 3000 the last leaf of the consolidation

and year 2011 to be as it is 6000

Thank for your reply i hope you understand a bit better now
回复 支持 反对

使用道具 举报

69

主题

368

帖子

521

积分

高级会员

Rank: 4

积分
521
QQ
发表于 2014-3-20 09:17:26 | 显示全部楼层
Why not set the element weights on the time dimension so that for normal consolidated periods only the last child period counts? If you need to use the time dimension in another cube that has normal aggregation then create and maintain two time dimensions, one for each method. You might also need one for "time first" aggregation (opening balance?).

If you need different measures in the same cube to use different time aggregation methods then you could do your "time last" aggregation in a separate cube. Source the leaf data in the "time last" aggregation cube from appropriate measures in the main cube and source the consolidated data for the "time last" measures in the main cube from the aggregation cube.
回复 支持 反对

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-20 10:47:33 | 显示全部楼层
You could create a system/mapping cube that has your time dimension and a string dimension, then store the last submission in the cube as a string, updating this whenever you run the upload process. Then supply this to your rule as a DB reference.

cube     
sys_submission_reference
dim      
CRL Bar Period
measure

           
2011     25/10/2011
Sep-11  30/09/2011
Oct-11  25/10/2011

note, I've simplified the cube structure;

[ 'Register' ] = C: DB( 'Test1', !Version, !Region, 'Register Available', DB( 'sys_submission_reference', !CRL Bar Period, 'string'));

Issue may be that it is very generically fed;

[ 'Register Available' ] => [ 'Register' ];
回复 支持 反对

使用道具 举报

70

主题

390

帖子

554

积分

高级会员

Rank: 4

积分
554
QQ
发表于 2014-3-20 10:54:31 | 显示全部楼层
Thanks,

I Will try what you said and get back to you with my results
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-12-16 15:56 , Processed in 0.147921 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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