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!