July 26, 2012 Microsoft released Service Pack 2 (SP2) for SQL Server 2008 R2
On July 26, 2012 Microsoft released Service Pack 2 (SP2) for SQL Server 2008 R2.
SQL Server 2008 R2 Service Pack 2 contains Cumulative Update 1 to 5 from SQL Server 2008 R2 SP1.
List of fixes related to SQL Server Analysis Services 2008R2:
|
Release |
SQL Bug Number |
KB Article Number |
Description |
|
| SP1 CU1 | 746736 | 2547017 | FIX: Instances of DAX functions that have no names incorrectly appear when you add a calculated member to a report that uses an SSAS 2008 R2 database as a data source | |
| SP1 CU1 | 746729 | 2535660 |
FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2 | |
| SP1 CU1 | 718953 | 2531172 | FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 R2 Analysis Services | |
| SP1 CU1 | 718910 | 2521127 | FIX: PowerPivot window does not open when you open an .xla or .xlam file in Excel 2010 if PowerPivot for Excel 2010 is installed | |
| SP1 CU1 | 718946 | 2518876 | FIX: MDX query incorrectly returns NULL or 0 values for some measures if a calculated member is used on the row axis in SSAS 2008 R2 | |
| SP1 CU2 | 726744 | 2535660 | FIX: Role membership is synchronized even if the SynchronizeSecurity element is set to the SkipMembership value in SSAS 2008 or in SSAS 2008 R2 | |
| SP1 CU2 | 748217 | 2567763 | FIX: Aggregation design assignment might be removed in SSAS 2008 R2 if you run the Analysis Services Deployment Wizard to deploy a database | |
| SP1 CU3 | 768890 | 972777 | FIX: The SQL Server 2008 Analysis Services and SQL Server 2008 R2 Analysis Services service stops responding when you run an ALTER command on a database while an UPDATE CUBE statement is running on the database | |
| SP1 CU3 | 783501 | 2562396 | FIX: Exception when an MDX query uses the Crossjoin function in SSAS 2008 R2 if more than 4 billion tuples are returned | |
| SP1 CU3 | 783511 | 2588016 | "Internal error: An unexpected exception occurred" error when you run the ProcessUpdate command if you modify the aggregation design of a dimension in SSAS 2008 R2 | |
| SP1 CU3 | 783500 | 2588047 | FIX: MDX query incorrectly returns a NULL value in SSAS 2008 R2 if a linked cube contains a many-to-many dimension and a distinct count measure group | |
| SP1 CU3 | 783513 | 2590200 | FIX: "The results of the current statement cannot be stored on the server" error when UpdateCells commands concurrently perform many writeback operations in SSAS 2008 R2 | |
| SP1 CU3 | 794998 | 2619924 | FIX: SQL Server 2008 R2 SP1 does not update Microsoft.AnalysisServices.SharePoint.Integration.dll module | |
| SP1 CU3 | 797720 | 2624056 | FIX: Status window does not have text for the process progress when you process SSAS 2008 R2 objects in BIDS or SSMS | |
| SP1 CU4 | 738050 | 2562753 | FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension | |
| SP1 CU4 | 812723 | 2626637 | FIX: DRILLTHROUGH statement does not work if it is run against some attribute members whose values contain one or more double quotation marks in SSAS 2008 R2 | |
| SP1 CU4 | 804578 | 2629168 | FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2 | |
| SP1 CU4 | 827315 | 2638216 | FIX: Error message when you run a query that uses an MDX reserved keyword as a parameter name in SSAS 2008 R2 | |
| SP1 CU4 | 834224 | 2652582 | FIX: "Invalid authorization specification" error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode | |
| SP1 CU5 | 799333 | 2605756 | FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008 or to SSAS 2008 R2 | |
| SP1 CU5 | 854092 | 2636425 | FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2 | |
| SP1 CU5 | 853102 | 2653917 | FIX: "The data refresh job failed because it has been inactive for more than 3600 seconds" error message when you use SQL Server 2008 R2 PowerPivot for SharePoint in some non-English environments | |
| SP1 CU5 | 858625 | 2659075 | FIX: Permissions across multiple roles are not additive as expected in SSAS 2008 R2 | |
| SP1 CU5 | 860062 | 2661225 | FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer | |
| SP1 CU5 | 856454 | 2675230 | FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators | |
| SP2 | 728527 | 2216456 | SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services |