If…Then..Else… in MultiDimensionalExpression

A logical script in MDX to perform an “If..Then.. Else..” block.

Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise:

Example2:The following string returns the string “Yes” if Measures.CurrentMember is an empty cell, the string, “No” otherwise:

Example3:

Example4:Average Sales (Measure) By Time Day (Dimension)

Source:

SQL Server 2000 Book Online (F1)

MDX Solution With Microsoft SQL Server Analysis Service (Wiley) (George Spofford)

Terimakasih!

Leave A Comment

Your email address will not be published. Required fields are marked *