none
Filter and MDX query using different hierarchy RRS feed

  • Question

  • 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!

    Thursday, December 11, 2014 7:38 PM