A logical script in MDX to perform an “If..Then.. Else..” block. IIf(«Logical Expression», «Numeric/String Expression1», «Numeric/String Expression2») Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise: IIf(IsEmpty(Measures.CurrentMember), 0, 1) Example2:The following string returns the string “Yes” if Measures.CurrentMember is an empty cell, the string, “No” otherwise: IIf(IsEmpty(Measures.CurrentMember), “Yes”, “No”) Example3: IIf(… Continue reading →