Posts Tagged “ssas”
SSAS: Mastering MDX on SSAS
by diditho on July 21, 2011
The Next step on using SQL Server Analysis Service (SSAS) as Business Intelligence (BI) / Warehouse (BW) platform is to master Multi Dimensional Expression (MDX), it’s like Query on T-SQL. Question, how to master MDX script language on SSAS (SQL (…)
SSAS: MDX Average Script On SSAS 2008
by diditho on June 7, 2011
The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008. SSAS 2008, How to calculate Net Value By Date (NetValue (…)
Multiple IIf Logic Block
by diditho on June 25, 2008
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", (…)
If…Then..Else… in MultiDimensionalExpression
by diditho on June 25, 2008
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 (…)
Relative Contribution to Total Value (Percentage)
by diditho on June 24, 2008
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 (…)
