MDX Where clause

Posted by Jeff Rix on January 13, 2012 under MDX | Be the First to Comment

This MDX query shows delinquent balance and original principal balance across the servicing plan members with a rate type id equal to 1.

SELECT {[measures].[Delinquent Balance], [measures].[Original Principal Balance]} ON COLUMNS ,NON EMPTY [Servicing Plan WID].[Servicing Plan ID].MEMBERS ON ROWS FROM [Cube T]
WHERE {([Dim Rate Type].[Rate Type ID].&[1])};