Posts tagged "analysis service"

Microsoft Analysis Service (OLAP) Front-End

Option for MSSQL Analysis Service (OLAP) Front-End 1.Microsoft SQL Reporting Service SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface 2.Microsoft PerformancePoint Service PerformancePoint Services in Microsoft SharePoint… Continue reading

SSAS: MDX Average Script On SSAS 2008

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 / Date)

Old one, SSAS 2000, How to calculate Net Value By Date (NetValue… Continue reading

Multiple IIf Logic Block

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:

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:


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

Source:… Continue reading