Error in MDX in PAX

Post Reply
Houps
Posts: 14
Joined: Tue Aug 31, 2021 12:04 pm
OLAP Product: Cognos Analytics
Version: 10.2.2
Excel Version: 2017

Error in MDX in PAX

Post by Houps »

Hello
I have this MDX {[Year{Month].[Jan 2021]:[Year{Month].[May 2021]}. It work fine
But when i try to do {[Year{Month].[&$G$1&]:[Year{Month].[&$G$2&]} or {[Year{Month].["&$G$1&"]:[Year{Month].["&$G$2&"]} in PAX.
It doen't work. Could some help me?
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Error in MDX in PAX

Post by declanr »

Houps wrote: Tue Aug 31, 2021 6:30 pm Hello
I have this MDX {[Year{Month].[Jan 2021]:[Year{Month].[May 2021]}. It work fine
But when i try to do {[Year{Month].[&$G$1&]:[Year{Month].[&$G$2&]} or {[Year{Month].["&$G$1&"]:[Year{Month].["&$G$2&"]} in PAX.
It doen't work. Could some help me?
Presumably it would need to be:
="{[Year{Month].["&$G$1&"]:[Year{Month].["&$G$2&"]}"

But is your dimension actually called Year{Month? Having a curly bracket in the middle of a dimension name looks a little bit unusual so I wonder if there is a typo there.
Declan Rodger
Houps
Posts: 14
Joined: Tue Aug 31, 2021 12:04 pm
OLAP Product: Cognos Analytics
Version: 10.2.2
Excel Version: 2017

Re: Error in MDX in PAX

Post by Houps »

It really help me. Thanks!
I have Year{Month dimension - i don't know why developer before make it
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Error in MDX in PAX

Post by Wim Gielis »

Very minor remark, I would write for readability:

="{[Year{Month].[" & G1 & "]:[Year{Month].[" & G2 & "]}"
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply