Hi there,

I'm new on OLAP, and I' stuck on a query - it might be a stupid question...but I'm really stuck!!!

This is part of the structure of my CUBE:
measure: NUMBER OF PURCHASES
dimensions: - USER
- GENDER
- STORE

How can I get the PURCHASE NUMBER for all the male USERs, with NUMBER OF PURCHASES>10, for the STORE XYZ?

I've tried this:

SELECT {[Measures].[NUMBER OF PURCHASES]} ON COLUMNS, Filter([USER].members, [Measures].[NUMBER OF PURCHASES] >10) ON ROWS, {[GENDER].[Male]} ON PAGES, {[STORE].[XYZ]} ON SECTIONS FROM mycube"

but it applies the filter on the total number of purchases, not only on the purchases for that particular store.

Any helps would be very appreciated.
Thanks,
Stefano