企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 763|回复: 1

assignment issue.

[复制链接]

82

主题

429

帖子

624

积分

高级会员

Rank: 4

积分
624
QQ
发表于 2014-3-20 04:27:04 | 显示全部楼层 |阅读模式
I have a cube1, cube 2.

Cube1 has dim1,dim2,dim3,Measuredim
cube2 has dim1,dimX,dim2,dim3,Measuredim

dim2 has text attribute - 'category', which contains corresponding category of the elements in dim2. dimX is a dimension which holds category as elements. Now I want to source the data(using rule)from cube1 to cube2 such that the category of dim2 matching to the elements of dimX.

dim2:
element(text Attribute-category)
---------------------------------
a1(category1)
a2(category1)
a3(category2)
a4(category2)
a5(category2)
a6(category2)
a7(category2)
a8(category3)
a9(category3)
a10(category3)


where as dimX has the following elements:
category1
category2
category3
category4
category5

my intention is (I know this below code will not work)
DB('Cube2',!dim1,ATTRS('dim2',!dim2,'Category'),!dim2,!dim3,'Nvalue')=DB('Cube1',!dim1,!dim2,!dim3,'Nvalue');

Can anyone help me in providing the solution for the above statement.

Thanks in advance.

Regards,
-Ramesh.
回复

使用道具 举报

83

主题

416

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-3-20 05:28:05 | 显示全部楼层
Think something like
Code: #Rule, in cube2
[] = n: if(
  attrs('dim2',!dim2,'Category') @= !Dimx,
  DB('Cube1',!dim1,!dim2,!dim3,'Nvalue'),
#else
  0);
# and feeder, in cube 1
[] => DB('Cube2',!dim1,
  'All Categories',
  !dim2,!dim3,'Nvalue');


should do it. Won't be a very small feeder though.

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2023-10-3 09:30 , Processed in 0.089503 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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