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.
Symptoms
Consider the following scenario:
-
On a computer that is running SQL Server 2008 R2, you create an Analysis Services project or a Report Model project in SQL Server Business Intelligence Development Studio (BIDS).
-
In the project, you create a data source that uses the Microsoft SQL Server 2008 R2 Parallel Data Warehouse .NET Provider to connect to the Microsoft SQL Server Parallel Data Warehouse.
-
You create a data source view that is based on the data source. Then, you try to create a named query.
In this scenario, the named query is not created.
When this problem occurs, you may receive an error message that resembles the following:
Keyword not supported
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.
Cause
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.
Resolution
Cumulative update information
SQL Server 2008 R2
The 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:
2345451 Cumulative Update package 4 for SQL Server 2008 R2 Note 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:
981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More Information
For more information, visit the following Microsoft webpages:
Defining Named Queries in a Data Source View (Analysis Services)
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)For more information about a related issue, click the following article number to view the article in the Microsoft Knowledge Base:
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
