Filter in a KPI's MDX formula RRS feed

  • Question

  • Hi,

    The following MDX query works when I put it in the cube, but does not work when I put it in my KPI's formula.

    sum({[Date].CurrentMember.PrevMember}, iif([Client].[Area] is [Client].[Area].&[01], [Measures].[Sales], null))

    If I put "All" instead of "01", that works (but indeed I do want my filter on "01").
    Does someone have an idea?

    Thursday, February 7, 2008 8:14 AM