dev

IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple to implement single block of IIf block. This an example of Multiple IIf logic block. Example1: 1 2 3 4 IIf(Measures.[Store Sales] > 50000, "Good", IIf(Measures.[Store Sales] > 30000, "Average", IIf(Measures.[Store Sales] > 10000, "Poor", "No")))

A logical script in MDX to perform an “If..Then.. Else..” block. 1 IIf(«Logical Expression», «Numeric/String Expression1», «Numeric/String Expression2») Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise: 1 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: 1 IIf(IsEmpty(Measures.CurrentMember), "Yes", [...]

There’s a few scenario to calculate a percentage of a measure in OLAP CUBE (Analysis Service 2000). A Percentage is common calculation in MDX , and it can be solved by divide a measure to  total value (Grand Total). Sample 1:Measures.[Value Contribution to Total]: 1 (Measures.[Value] / (Measures.[Value], Time.[ALL Time], Products.[ALL Products],…) Sample 2:Measures.[Value Contribution [...]