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:

IIf(Measures.[Store Sales] > 50000, "Good",
IIf(Measures.[Store Sales] > 30000, "Average",
IIf(Measures.[Store Sales] > 10000, "Poor",
"No")))

Related posts:

  1. Multi Dimensional Expression Basic (MDX) This post is copy from http://gumper.com, a unique website coz...
  2. If…Then..Else… in MultiDimensionalExpression A logical script in MDX to perform an “If..Then.. Else..”...
  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. Pilah – Pilih Sekolah Yuk… Ternyata benar juga kata orang, kalau urusan memilih sekolah untuk...
  7. WordCamp Jakarta 2017, Drop-in dan Must-Use (MU) Plugins Di WordCamp Jakarta 2017  saya memiliki kesempatan untuk berbagi pengalaman...
  8. CURSOR FETCH on SQL Server although CURSOR and FETCH is classified as ‘evil‘ in SQL...

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.