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
MDX help with 2 dimensions on rows
-
- 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
Thanks
Micheline
Micheline
-
- MVP
- Posts: 3123
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: MDX help with 2 dimensions on rows
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.
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
IBM Champion 2024
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
Wim Gielis
IBM Champion 2024
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
-
- 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
Ok thank you for getting me out of my misery.
Thanks
Micheline
Micheline
-
- MVP
- Posts: 3123
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: MDX help with 2 dimensions on rows
You’re welcome. Well done to get it working.
Best regards,
Wim Gielis
IBM Champion 2024
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
Wim Gielis
IBM Champion 2024
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