Using Microsoft Excel Functions with SSAS 2005 Data Sources

If you are working with a Microsoft SQL Server 2005 Analysis Services (SSAS) data source and you want to use Microsoft Excel VBA functions such as ROUNDDOWN in MDX queries, the following Microsoft Office features must be installed on the SSAS server:
  • Microsoft Office Excel
  • Microsoft Visual Basic for Applications

To see a list of Excel VBA functions, see the Microsoft Web site (http://www.microsoft.com).

If these Microsoft Office features are not installed on the SSAS 2005 server, and you use Excel VBA functions, you encounter an error such as the following: YK-ERR-0008 The data provider returned an error message: "The '[Excel].[ROUNDDOWN]' function does not exist.".

This error occurs because the OLAP server cannot process the function since Excel function libraries are missing.

For more information, see the Microsoft Knowledge Base article 932214 at http://support.microsoft.com.