1

I am struggling with the Type Mismatch error when I query the cube in SSAS. The MDX query is shown below:

WITH 
    MEMBER [MEASURES].[TopNFilter] AS 
        IIF
        (
            Count((EXISTING Exists([DimClient].[Client].CurrentMember,TopNSet))) > 0,
            1,
            -1
        ) 
SELECT 
    {
        [MEASURES].[Volume],
        [TopNFilter]
    } ON COLUMNS,
    {TopNSet} ON ROWS
FROM [Cube];

How can I fix this error

whytheq
  • 34,466
  • 65
  • 172
  • 267
Mike Eale
  • 101
  • 1
  • 9

1 Answers1

0

Sorry for the brevity but the engine will not know the type of this word:

TopNSet

The rest of the syntax looks like valid MDX

whytheq
  • 34,466
  • 65
  • 172
  • 267