|
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. |
|