TM1 Forum

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

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.

Ok thank you for getting me out of my misery.

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.