To get the element name in dimension using the attributes name in tm1

Post Reply
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

To get the element name in dimension using the attributes name in tm1

Post by kavitha2002 »

Hi Everyone,

In TM1, is there a way to get the element name using the attributes name in }ElementsAttributesCube using MDX statement.

Thanks in advance
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: To get the element name in dimension using the attributes name in tm1

Post by Elessar »

Hi,

If the attribute is alias, you can just use "{[Dimension].[AliasValue]}" and switch alias OFF in subset.
If it is not, there can be several elements with this attribute, so you can filter by this attribute: {FILTER( {TM1SUBSETALL( [Dimension] )}, [Dimension].[AttributeName] = "AttributeValue")}
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Post Reply