Review the information in these sections if you are using Expression Editor in any of the following specific situations:
You must consider the following when creating expressions using an SAP BW data source, or you may not get the results you expect:
The case and if/then/else constructs are not supported in filters.
The query item identifier of the leaf-level of the 0CALDAY characteristic and its presentation hierarchies is of type date. When the values for the query item identifier are presented in Report Studio, they are formatted as dates. These formatted values should not be used in filter expressions. The correct date constant format for use in expressions is YYYY-MM-DD.
You can apply a comparison expression with an operator other than equals to a query item that represents a level identifier. However, level identifiers are more efficient for identifying specific values. Range comparisons must be performed on the IBM Cognos 8 application server, which slows down the performance of the report.
If you are working with a Microsoft SQL Server 2005 Analysis Services (SSAS) data source and you want to use 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://technet.microsoft.com/en-us/library/aa178231(SQL.80).aspx).
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 at http://support.microsoft.com/kb/932214.