Returning Alias using ELCOMP

Post Reply
anguscat
Posts: 1
Joined: Wed Nov 02, 2011 8:40 pm
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2010

Returning Alias using ELCOMP

Post by anguscat »

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
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Returning Alias using ELCOMP

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Returning Alias using ELCOMP

Post by qml »

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.
Kamil Arendt
Post Reply