Filtering works in "MDX query mode" when we manually write query. To run it you should switch to MDX mode.
examples which works on:
1) official demo, 'Sales' cube :
SELECT NON EMPTY {Hierarchize( {[Measures].[Store Sales]}
)} ON COLUMNS, Filter (Customers.Name.Members, Measures.Store Sales <60 ) ON ROWS FROM Sales
2) local cube
SELECT NON EMPTY Filter(CrossJoin(Loan.Loan Details.Amount Repaid.Members, {[Measures].[Loan/Amount Repaid]}
), Measures.Loan/Amount Repaid > 26000) ON COLUMNS, NON EMPTY {Hierarchize( {[Clients.Client Details].[Client Display Name].Members}
)} ON ROWS FROM Loans
Notes:
Custom MDX filter worked in case when we have selected following objects to columns: Measures.Amount Repaid and Loan.Amount Repaid
to rows: Clients.Display Name
and have written following to the column MDX filter: Measures.Loan/Amount Outstanding > 26000
|