企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 465|回复: 6

Pulling values from other cubes using rules.

[复制链接]

81

主题

429

帖子

608

积分

高级会员

Rank: 4

积分
608
QQ
发表于 2014-3-19 03:41:48 | 显示全部楼层 |阅读模式
Hi Folks,

I am trying to pull values from one cube to another. Here is the scenario.

I have two cubes one is the main cube named 'All Expense' having these dimensions
Function
Department
Central Nature
Scenario
Facility
Year
Months
Expense Measures

I am pulling values from an other cube named as 'Long term disability Insurance' having the dimensions listed below into the 'All Expense' cube
Function,
Facility
Year
Scenario
Employee(Attributes:Facility(text),Department(Text)).
Employee Insurance Measure

Now the department resides in the attribute of the employee dimension and i want to pull the details of only the departments pertaining to the employee.

This piece of code works fine but I am not sure if it will give me the results as expected.

['Amount LC']=NB('Long Term Disability Insurance',!Function,!Facility,!Year,'Budgeted',!Department,'Employer Premium LC');

I get error when i try to do something like this.

['Amount LC']=NB('Long Term Disability Insurance',!Function,!Facility,!Year,'Budgeted',ATTRS('Employee',!Employee,'Department'),'Employer Premium LC');


Really confused as to how to retrieve the values in such cases or do I have to put another dimension in the 'Long Term Disability Insurance cube'?

I Request someone to kindly help me in this regards.

Thanks,
Ravi Ahuja.
回复

使用道具 举报

87

主题

397

帖子

595

积分

高级会员

Rank: 4

积分
595
QQ
发表于 2014-3-19 04:54:34 | 显示全部楼层
Employee as a dimension only exists in the cube that you are getting data from. You can only get attributes from dimensions for the cube that rule is attached to. That's your problem.
回复 支持 反对

使用道具 举报

76

主题

396

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-3-19 05:14:07 | 显示全部楼层
The easiest solution would be to create new consolidations in the Employee dimension, grouping Employees into the same departments that are then used in the Department dimension in the second cube. Your first rule would then work nicely and there would be no need to use attributes either.

And you can't really use attributes of the Employee dimension in that way, because !Employee will not be resolved properly in the context of the target cube as it does not have that dimension.
回复 支持 反对

使用道具 举报

69

主题

368

帖子

521

积分

高级会员

Rank: 4

积分
521
QQ
发表于 2014-3-19 05:54:25 | 显示全部楼层
qml wrote:And you can't really use attributes of the Employee dimension in that way, because !Employee will not be resolved properly in the context of the target cube as it does not have that dimension.

Is it me or did I just say that??? Probably me.
回复 支持 反对

使用道具 举报

85

主题

414

帖子

607

积分

高级会员

Rank: 4

积分
607
QQ
发表于 2014-3-19 06:12:00 | 显示全部楼层
still it will not be dynamic as i want, because if i create a consolidation for department it would be something like this.

['Amount LC','<A department code>']=NB('Long Term Disability Insurance',!Function,!Facility,!Year,'Budgeted','<A department code>','Employer Premium LC');


I will have to hard code this which i want to avoid because I have a big list of departments.

Likewise is the case with the Chart of accounts which gets stored in the respective employee attribute. Is there a way around for this?
回复 支持 反对

使用道具 举报

66

主题

395

帖子

544

积分

高级会员

Rank: 4

积分
544
QQ
发表于 2014-3-19 06:46:58 | 显示全部楼层
ravi.ahuja21 wrote:I will have to hard code this which i want to avoid because I have a big list of departments.
No, you won't. There are ways of keeping the rule generic, for example create an attribute for Department (and set its value to something for those Departments that you want to pull data from the other cube) and then check on the right hand side of that rule using an IF statement if a given Department has that attribute set to something. If yes, calculate rule, if not, stet or whatever.
jim wood wrote:Is it me or did I just say that??? Probably me.
Am I not allowed to have the same opinion?    Especially if it's the right opinion?  

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-19 06:47:08 | 显示全部楼层
qml wrote:Am I not allowed to have the same opinion?    Especially if it's the right opinion?  

Of course you're allowed. Sometimes my mind and fingers disconnect so what I mean to say doesn't actually come out the way I mean to say it. I have to check these things sometimes.

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-7-5 15:00 , Processed in 0.212082 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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