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 » Tue May 22, 2018 8:32 am

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: 1748
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Tue May 22, 2018 8:54 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

David Usherwood
Site Admin
Posts: 1329
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 » Tue May 22, 2018 8:57 am

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

Post Reply