Attributes referencing in MDX queries

Post Reply
Yashid
Posts: 1
Joined: Fri May 23, 2025 10:34 am
OLAP Product: TM1
Version: Tm1_winx64h_2.0.920.58
Excel Version: 2412

Attributes referencing in MDX queries

Post by Yashid »

Hi All
Is there a way to display an attribute from MDX query.
In the below highlighted second part of the Period query, I need to display an attribute Quarter instead of displaying Mar, Jun, Sep, Dec (element ID) but want to keep element IDs as is in the first Period query

{

{STRTOSET( "{[YEAR].[YEAR].[2024].NEXTMEMBER}")}
*
{[PERIOD].[PERIOD].[Total Year],[Period].[Period].[Jan],[Period].[Period].[Feb],[Period].[Period].[Mar],[Period].[Period].[Apr]} ,

{STRTOSET( "{[YEAR].[YEAR].[2024].NEXTMEMBER.NEXTMEMBER}")}
*
{[Period].[Period].[Mar],[Period].[Period].[Jun],[Period].[Period].[Sep],[Period].[Period].[Dec]}
}
User avatar
gtonkin
MVP
Posts: 1259
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Attributes referencing in MDX queries

Post by gtonkin »

Have a look for some guidance in this article.

If you are trying to convert the value in the attribute to a member, you will need to use StrToMember()
If you are trying to display the attribute in a view then you need to create a calculated member.

Either way, the content in the articles should guide you.
BR, George.

Learn something new: MDX Views
Post Reply