MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)

Post Reply
cecilia.andersson3
Posts: 1
Joined: Tue May 22, 2018 8:04 am
OLAP Product: Planning Analytics
Version: Planning Analytics
Excel Version: 2016

MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)

Post by cecilia.andersson3 »

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!
Wim Gielis
MVP
Posts: 3103
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)

Post by Wim Gielis »

For example,

Code: Select all

{FILTER({Subset ( {TM1FilterByLevel(TM1SubsetAll ( [Kund] ) , 2)}, 11, 10)}, [Test].([Posting Measures].[Amount]) > 0 )}
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, ...
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
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)

Post by David Usherwood »

EXCEPT should do what you want
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=113
ie (pseudo-code)
except([Top20],[Top10])
Post Reply