I have a problem coming up with an MDX statement for the following
situation.

Given the following dimension
Customer
Gender
City
JobTitle
MaritalStatus

How do I view the count of Gender by MaritalStatus where City='Seattle'
OR JobTitle='Programmer'?

in SQL I would write:
SELECT COUNT(*) FROM Customer WHERE JobTitle='Programmer' OR
City='Seattle'
GROUP BY Gender, MaritalStatus

My current solution is:

FILTER(CROSSJOIN([JobTitle].[All].Children,[City].[All].Children),
[City].MemberValue='Seattle' OR [JobTitle].MemberValue='Programmer')


Any ideas how I can improve this?

Here is an example against the Advenure Works sample database that gets
a Customer count for Marital Status = "Married" or Occupation =
"Clerical"

{[Measures].[Customer Count]} ON COLUMNS
FROM [Adventure Works]
WHERE
UNION({([Customer].[Marital Status].[Married]
,[Customer].[Occupation].[All Customers])}
,{([Customer].[Marital Status].[All Customers]
,[Customer].[Occupation].[Clerical])}
)
Basically you get a set unioning Married with all occupations and
Clerical with all marital status.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1147827597.797807.97600 (AT) y43g2000cwc (DOT) googlegroups.com>,
whbmitchell (AT) Hotmail (DOT) com says...