MDX filter on Customer dimension (11-20th member) based on revenue (measurements dimension)
Posted: 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!
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!