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

Post Reply
kavitha2002
Posts: 15
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 » Wed Jun 20, 2018 12:30 pm

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
Posts: 131
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Russia

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

Post by Elessar » Wed Jun 20, 2018 1:10 pm

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")}
Sorry for my English ;)

Post Reply