TM1 Forum

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?

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.

It really help me. Thanks!
I have Year{Month dimension - i don't know why developer before make it

Very minor remark, I would write for readability:

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