Filter and MDX query using different hierarchy

How can I filter an MDX query to show several sets of data with a filter to
exclude certain ID numbers from a different hierarchy.
For example below, what would be the syntax for the NOT IN part?

 SELECT [Measures].[Gross GAAP Par OS Amt] ON COLUMNS,
 FILTER(
    [Policy].[Policy Name].[Policy Name] * [Policy].[Policy ID].[Policy ID],
    [Policy].[Policy ID].Members
     ****NOT IN [NEW_Policy].[Policy ID].AllMembers****
 )
 ON ROWS
 FROM EXPOSURE


Thanks!

December 11th, 2014 10:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics