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
Returning Alias using ELCOMP
-
- 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
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.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?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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
This can be easily achieved by using the ATTRS() rule/TI function or the DBRA() worksheet function.
Example:
Edit: what a surprise, Alan beat me to it.
Example:
Code: Select all
sElement = ATTRS ('Dimension', ELCOMP ('Dimension', sParent, nPosition), 'Alias');
Kamil Arendt