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]}
}
Attributes referencing in MDX queries
- 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
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.
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.