Hi,
I am trying to create an MDX filter on the "Customer" dimension based on revenue ("Measurements" dimension) for the 11-20th members.
I have 1 cube with 11 dimensions, which includes the Customer and Measurements dimensions.
I have found these two filters, which I believe I could use but I just don't know how to combine them. Any ideas?
{Subset ( {TM1FilterByLevel(TM1SubsetAll ( [Kund] ) , 2)}, 11, 10)}
{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product] )}, 0)},
[Test].([Posting Measures].[Amount]) > 0 )}
Appreciate any guidance! Many thanks!
MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)
-
- Posts: 1
- Joined: Tue May 22, 2018 8:04 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics
- Excel Version: 2016
-
- MVP
- Posts: 3126
- 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 filter on Customer dimension (11-20th member) based on revenue (measurements dimension)
For example,
and you will want to restrict the selection in the Test cube more such as to come to the desired results. Select in the cube on year, period, scenario, ...
Code: Select all
{FILTER({Subset ( {TM1FilterByLevel(TM1SubsetAll ( [Kund] ) , 2)}, 11, 10)}, [Test].([Posting Measures].[Amount]) > 0 )}
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
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)
EXCEPT should do what you want
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=113
ie (pseudo-code)
except([Top20],[Top10])
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=113
ie (pseudo-code)
except([Top20],[Top10])