企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 874|回复: 11

Better design and implementation

[复制链接]

66

主题

394

帖子

543

积分

高级会员

Rank: 4

积分
543
QQ
发表于 2014-3-16 18:34:32 | 显示全部楼层 |阅读模式
Hi,
I have developed a cube with the dimensions;
Customer
Account
Version
Months
Year
Bands
Employee Details
the requirements when user selects the Plan version, first we must identify what is the current month?,based on the current month the quarter should be editable.
Like if we are in jun then Apr,May and jun should be editable remaining should be blocked,This should be dynamic.

First I have tried by writing rule(many)
['plan','Feb']=S:''; in the same way for remaining months.

Second I tried with security but I did not meet the requirements.

Please find the attachment for the cube I modeled.
回复

使用道具 举报

71

主题

366

帖子

519

积分

高级会员

Rank: 4

积分
519
QQ
发表于 2014-3-16 20:16:58 | 显示全部楼层
for the current month I tried like
['Plan','Employee cost']=S:Month(DATE(Now())=6,Read, write);this rule i have written for control cube
回复 支持 反对

使用道具 举报

85

主题

419

帖子

604

积分

高级会员

Rank: 4

积分
604
QQ
发表于 2014-3-16 20:18:01 | 显示全部楼层
any suggestions.
回复 支持 反对

使用道具 举报

83

主题

392

帖子

567

积分

高级会员

Rank: 4

积分
567
QQ
发表于 2014-3-16 20:34:21 | 显示全部楼层
charan wrote:any suggestions.

Only one; patience. You asked the question only 5 hours ago. At that time it was already close to going home time in the eastern US, late evening or well into the night in Europe, and a bright shining morning in asia-pac... where a lot of us work on a 30 June financial year and are too buried under annual budgets and end of year reporting just now to answer as many questions as we otherwise might.

I appreciate that you'd like to get a reply as soon as you can but you don't need to bump the thread that soon, just wait for nature to take its course...
回复 支持 反对

使用道具 举报

81

主题

410

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-16 20:41:15 | 显示全部楼层
Hi, unsure if this helps. for numeric, write N: based rules

Could use ELPAR to find the matching Qtrs but best to  create an attribute 'QTR' for each leaf element
Code: # Do not allow input to non plan quarter
['Plan','Ecost'] = N:
   IF(
      # The current month within the months quarter
     ATTRS('Month', !Month, 'QTR') @= ATTRS('Month', DB('Control', 'Item', 'Current Month'), 'QTR')      
       ,
      # Allow input
      STET,
      # otherwise zero
      0   
                );


['Plan','Employeename'] = S:
   IF(
      # The current month within the months quarter
                                 ATTRS('Month', !Month, 'QTR') @= ATTRS('Month', DB('Control', 'Item', 'Current Month'), 'QTR')      
       ,
      # Allow input
      STET,
      # otherwise zero
      ''   
                );
note: use CONTINUE instead of STET if you  have furher calcs on the intersections

btw, use element names not aliases in rules if you can, they wont  ever change (unless deleted), while aliases may

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

69

主题

365

帖子

518

积分

高级会员

Rank: 4

积分
518
QQ
发表于 2014-3-16 21:00:03 | 显示全部楼层
When you mention blocked, i would believe the data will still be there, just that the user will not have access to change the data that is already on the cell. Can you write rules on the Months security cube to determine which month has write access ?

You might need to set up a separate account which does not have admin permission to test it.
回复 支持 反对

使用道具 举报

64

主题

354

帖子

512

积分

高级会员

Rank: 4

积分
512
QQ
发表于 2014-3-16 21:14:59 | 显示全部楼层
oh, still want data to be retained in the other months? ok, scrap my  rules example above

Could use rules to drive the security as winsonlee describes, but if its only applicable to  Plan version then it may be cell level security, which you want to be careful with due to performance overheads

Either way, if you are rolling over  your 'current month' each new period, you can write the same logic into a TI process and reduce any  rule overhead issues (as its only  data)
回复 支持 反对

使用道具 举报

81

主题

411

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-16 21:57:26 | 显示全部楼层
Winsonlee,
Yeah your thought is correct user should not enter any data.
Thank you
回复 支持 反对

使用道具 举报

81

主题

429

帖子

608

积分

高级会员

Rank: 4

积分
608
QQ
发表于 2014-3-16 22:12:12 | 显示全部楼层
Big G,
Thank you very much,
I have doubt in the rule,
QTR is an attribute with 1,2,3....12 for the month dimension or any other thing their according to your suggestion?

In the control cube I did not get the design according to you, How to pick the current month in the control cube?

Thanks and regards
回复 支持 反对

使用道具 举报

64

主题

404

帖子

556

积分

高级会员

Rank: 4

积分
556
QQ
发表于 2014-3-16 22:14:57 | 显示全部楼层
QTR is an attribute with 1,2,3....12 for the month dimension or any other thing their according to your suggestion?
yes, the month dimension months

But that will wipe data in all months other than the 'current' quarter... might want to lkook at  dim or cell level secuirty
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-11-24 13:52 , Processed in 0.141870 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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