Article ID: 2431362 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Consider the following scenario:
When this problem occurs, you may receive an error message that resembles the following:
Note The use of the .NET provider for SQL Server 2008 R2 Parallel Data Warehouse is supported only for Report Model projects. Analysis Services projects for the SQL Server Parallel Data Warehouse should use the OLE DB provider instead.
Keyword not supported
The issue occurs because the SQL editor that is used to edit the named queries does not support the SQL Server Parallel Data Warehouse version of the SQL language.
Cumulative update information
SQL Server 2008 R2The fix for this issue was first released in Cumulative Update 4. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
2345451Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2345451/ )Cumulative Update package 4 for SQL Server 2008 R2
(http://support.microsoft.com/kb/981356/ )The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, visit the following Microsoft webpages:
Defining Named Queries in a Data Source View (Analysis Services)For more information about a related issue, click the following article number to view the article in the Microsoft Knowledge Base:
How to: Add, View, Modify, or Delete a Named Query Using Data Source View Designer (Analysis Services)
Create/Edit Named Query Dialog Box (Analysis Services - Multidimensional Data)
(http://support.microsoft.com/kb/2428397/ )FIX: Error "Type mismatch" when you try to delete an embedded PowerPivot database from a SQL Server 2008 R2 Analysis Service instance installed in the SharePoint integration mode