Page 1 of 1

Dynamic Dimension

Posted: Thu May 28, 2015 8:29 am
by sridhar.s
Hi, in TM1 is it possible to create a dynamic dimension from the values of another cube.
if it is possible cud u provide some idea.
I am using 10.2 version.
Thanks

Re: Dynamic Dimension

Posted: Thu May 28, 2015 8:45 am
by TrevorGoss
Hello,

yes it is quite possible, you can use the CellGetS or CellGetN function, while loop around the cube and passing the return values into another function which creates elements into the newly created dynamic dimension you want.

Any more questions, just ask.

Trevor.

Re: Dynamic Dimension

Posted: Thu May 28, 2015 10:47 am
by Wim Gielis
Yes sure. For example, create a cube view as a data source, and in the Advanced > Metadata tab you simply do a DimensionElementInsert statement.
Use DimensionElementComponentAdd to add the newly inserted element as a child to a different element.
Should be rather straightforward actually, if you understand what a TI process is all about and how it operates.

Re: Dynamic Dimension

Posted: Thu May 28, 2015 11:54 am
by TrevorGoss
Yes sure. For example, create a cube view as a data source, and in the Advanced > Metadata tab you simply do a DimensionElementInsert statement.
Use DimensionElementComponentAdd to add the newly inserted element as a child to a different element.
Indeed, he could also use the direct functions, to add attributes straight away if he needs to.

It seems as if the use of the world values is ambiguous, which is why I suggested going into the cells of the cube and using those values as new elements.

But you are right, TIs can handle this sort of stuff easily, so it is fairly straight forward.

Thanks.