Matching an element in attribute with element in dimension
Posted: Mon Sep 08, 2014 8:17 am
Hello
Would I be able to get some assistence with the issue I have come across as I am still on a learning curve on tm1 if poss please?
The situation is:
I have CUBE.1 (INPUT CUBE), CUBE.2 (REPORTING CUBE) and also a control cube.
I am working on CUBE.2 at the moment. I have created an attribute in one of the dimensions, calling a (string:M02) from the control cube. That has worked. Now I need to use that (string:M02) from the attribute, look through all the elements in DIM1( dimension in CUBE.2), try find a match (M02) and if match found, all the numbers that ARE in those cells (DIM1.ELEMENT1, DIM2.DATE1) , I want to put them in (DIM1.ELEMENT7. DIM2.DATE1)?
Hopefully that makes sense. Can anyone help?
Thank you
Would I be able to get some assistence with the issue I have come across as I am still on a learning curve on tm1 if poss please?
The situation is:
I have CUBE.1 (INPUT CUBE), CUBE.2 (REPORTING CUBE) and also a control cube.
I am working on CUBE.2 at the moment. I have created an attribute in one of the dimensions, calling a (string:M02) from the control cube. That has worked. Now I need to use that (string:M02) from the attribute, look through all the elements in DIM1( dimension in CUBE.2), try find a match (M02) and if match found, all the numbers that ARE in those cells (DIM1.ELEMENT1, DIM2.DATE1) , I want to put them in (DIM1.ELEMENT7. DIM2.DATE1)?
Hopefully that makes sense. Can anyone help?
Thank you