CODEWITHSUNDEEP
ssasmdxdata-warehouse
Christopher Townsend
Christopher Townsend

Reputation: 1746

MDX Filter Dimension Members Only

This is probably quite simple but I have a piece of MDX that filters all my customers, that have a balance over 100. This returns a set of tuples containing the customer and the balance. How do i return just a set of the customers?

Filter(
          [Customer].[Customer Name].Children,
          [Measures].[Balance] > 100
     )

I intend to use this as the expression for a named set in my cube.

Thanks in advance :)

Upvotes: 0

Views: 518

Answers (1)

Marc Polizzi
Marc Polizzi

Reputation: 9375

Note sure to understand how you get ( customer, balance ) tuples; anyway, you might be looking at the extract function. It allows you to retrieve the tuples with members of the specified hierarchy: e.g.,

Extract( my-set , [Customer].[Customer Name] )

Upvotes: 1

Related Questions