MDX help with 2 dimensions on rows

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

MDX help with 2 dimensions on rows

Post by mnasra »

HI Expert,

I am not a MDX expert, but I can write some.
I have an active report with 2 dimensions on rows (I cannot take them out).
Both of them have TM1RPTROW expressions. say DIM1 and DIM2

I am trying to FILTER on a measure of the cube. say: Mes = 'ABC'
So I wrote the filter this way on dim1; (leaving dim2 with a subset).

FILTER( {TM1SUBSETALL( [DIM1])}, [CUBE].([MESDIM].[MES] )= 'ABC')
it gives me the right Filter, but ONLY for the first value of DIM2.
It does not seem to go to the other values in DIM2.

Does what I want doable?
thanks
micheline
Thanks
Micheline
Wim Gielis
MVP
Posts: 2932
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.14
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: MDX help with 2 dimensions on rows

Post by Wim Gielis »

You use MDX for dimensions and their subsets.
But you really need MDX for cubes and their views.

Here is example syntax: https://social.msdn.microsoft.com/Forum ... isservices

You would put the MDX definition in for example a view in PAW. Classic TM1 and the cube viewer do not support it and never will.
Best regards,

Wim Gielis

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 https://github.com/wimgielis
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: MDX help with 2 dimensions on rows

Post by mnasra »

Ok thank you for getting me out of my misery.
Thanks
Micheline
Wim Gielis
MVP
Posts: 2932
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.14
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: MDX help with 2 dimensions on rows

Post by Wim Gielis »

mnasra wrote: Wed Aug 17, 2022 7:26 pm Ok thank you for getting me out of my misery.
You’re welcome. Well done to get it working.
Best regards,

Wim Gielis

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 https://github.com/wimgielis
Post Reply