TM1 Forum

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

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")}