TM1 Forum

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]}
}

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.