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)

Related posts:

  1. Multi Dimensional Expression Basic (MDX) This post is copy from http://gumper.com, a unique website coz...
  2. Multiple IIf Logic Block IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple...
  3. Relative Contribution to Total Value (Percentage) There’s a few scenario to calculate a percentage of a...
  4. SSAS: Mastering MDX on SSAS The Next step on using SQL Server Analysis Service (SSAS)...
  5. SSAS: MDX Average Script On SSAS 2008 The MDX script on Microsoft Analysis Service (SSAS) 2008 and...
  6. Encrypt and Decrypt Web.Config (Connection Strings, etc) from ASP Page Example: How to encrypt/decrypt connectionStrings and SessionState section on Web.Config...
  7. CURSOR FETCH on SQL Server although CURSOR and FETCH is classified as ‘evil‘ in SQL...
  8. Linked Servers, How To Read MySQL On SSMS 2008 A linked server configuration enables Microsoft SQL Server (MSSQL) to...

Leave A Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.