TM1 Forum

Posted: **Wed Nov 02, 2011 8:43 pm**

I am using the ELCOMP formula to return the children of an element. Is it possible to include the alias mask in the returned value?

Thank You,
Bill

Posted: **Wed Nov 02, 2011 9:01 pm**

anguscat wrote:I am using the ELCOMP formula to return the children of an element. Is it possible to include the alias mask in the returned value?

Not intrinsically as far as I'm aware, but the workaround is just to wrap the Elcomp inside a DBRA or AttrS function, depending on whether you're talking about the worksheet function or the rules one.

Posted: **Wed Nov 02, 2011 9:06 pm**

This can be easily achieved by using the ATTRS() rule/TI function or the DBRA() worksheet function.

Example:

Code: Select all

sElement = ATTRS ('Dimension', ELCOMP ('Dimension', sParent, nPosition), 'Alias');

Edit: what a surprise, Alan beat me to it.

TM1 Forum

Returning Alias using ELCOMP

Returning Alias using ELCOMP

Re: Returning Alias using ELCOMP

Re: Returning Alias using ELCOMP