Mar 19, 2014 - Microsoft released CU9 for SQL Server 2012 SP1
On Mar 19, 2014 Microsoft released Cumulative Update Package 9 (CU9) for SQL Server 2012 Service Pack 1 (SP1).
This update contains hotfixes for issues that were fixed after the release of SQL Server 2012. This build number of this cumulative update package is 11.0.3412.0.
List of fixes related to SQL Server Analysis Services / Powerpivot 2012 SP1:
|
Release |
SQL Bug Number |
KB Article Number |
Description |
| CU9 | 1993314 | 2921630 | FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2 or SSAS 2012 |
| CU9 | 1994687 | 2927524 | FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012 |
| CU9 | 2021039 | 2927748 | FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7 |
| CU9 | 1999683 | 2927844 | FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012 |
| CU8 | 1664719 | 2890818 | FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS 2008 R2 or in SSAS 2012 |
| CU8 | 1602236 | 2896903 | FIX: You cannot perform any administrator actions on the databases when a data model corruption occurs in SSAS 2012 |
| CU8 | 1683049 | 2912928 | FIX: SQL Server 2012 PowerPivot for SharePoint 2010 cannot create databases when SharePoint server name is FQDN |
| CU8 | 1852112 | 2912949 | FIX: SSAS crashes when more than one thread tries to access an SSAS 2008 R2 or SSAS 2012 cube at the same time |
| CU7 | 1499492 | 2889492 | You can’t open the SQL Server Analysis Services properties dialog box in Windows 8.1 |
| CU7 | 1530003 | 2890415 | Notification messages are not received when data updates fail in a PowerPivot sheet in an instance of SQL Server 2012 Service Pack 1 Analysis Services |
| CU7 | 1560706 | 2895694 | FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS 2012 |
| CU7 | 1599658 | 2896505 | Blank values for a DAX formula are seen in PowerPivot for Excel in SQL Server 2012 Analysis Services |
| CU7 | 1460938 | 2897263 | "An error occurred when loading VertiPaq data" error occurs after you run DISCOVER_XML_METADATA Rowset or load a database and then start a trace in SQL Server 2012 Analysis Services |
| CU7 | 1584328 | 2897265 | FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012 |
| CU7 | 1607493 | 2897282 | FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 on a non-US locale computer |
| CU7 | 1559163 | 2905275 | FIX: "The operation was cancelled by the user" error message when you run some MDX or DAX queries in SSAS 2012 |
| CU7 | 1460958 | 2905298 | FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012 |
| CU6 | 1293680 | 2847735 | FIX: "A PivotTable, cube function or slicer using connection |
| CU6 | 1347148 | 2860446 | FIX: An unexpected error occurs in function 'XMCompressionAnalyzer::SelectBitPackCompression' when you perform a Process command against a partitioned table in SSAS 2012 |
| CU6 | 1366483 | 2864111 | FIX: It takes longer than expected to cancel an MDX query that contains many GROUP BY clauses in SSAS 2012 |
| CU6 | 1405603 | 2872946 | FIX: CPU spinning occurs when you use Power View to run a DAX query against a Multidimensional model in SSAS 2012 |
| CU6 | 1377755 | 2874957 | FIX: Scheduled data refresh disabled after you make some modifications to the PowerPivot workbook in SharePoint 2013 that interacts with SSAS 2012 |
| CU6 | 1362520 | 2875158 | FIX: Inconsistent data order when you copy data from a PowerPivot worksheet to an Excel worksheet |
| CU6 | 1428782 | 2876882 | FIX: "Internal error: An unexpected error occurred" when you run a Process command against the TFS SSAS cube |
| CU6 | 1428185 | 2880071 | FIX: Error messages when you perform ProcessRecalc operation after the ProcessData operation on an SSAS 2012 tabular model |
| CU6 | 1328807 | 2880094 | FIX: Grand total or subtotal rows display incorrect result in a Power View report that runs against a multidimensional cube in SSAS 2012 |
| CU6 | 1402434 | 2884124 | FIX: "Type mismatch" error when you run an MDX query that uses the Member.Name property against an SSAS 2012 database |
| CU6 | 21593 | 2886673 | FIX: Incorrect returned value when you run an MDX query that contains a filter on a parent/child dimension in SSAS 2012 |
| CU5 | 1277961 | 2846345 | FIX: Slow performance when you render a Power View report that uses a SQL Server 2012 SP1 PowerPivot workbook as its data source |
| CU5 | 1319121 | 2850388 | FIX: "Index was out of range" error message when you use SSDT to create a perspective in SSAS 2012 |
| CU5 | 1325209 | 2852061 | FIX: MDX query excecution takes longer than expected in BIDS or SSDT in SQL Server 2012 |
| CU5 | 1330298 | 2854370 | FIX: Cannot update data in a workbook that uses a .bism file to connect to an SSAS instance |
| CU5 | 1338633 | 2863144 | FIX: Access violation when many users who belong to different roles run queries against a cube at the same time in SSAS 2012 |
| CU4 | 1207375 | 2800284 | FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2 or SSAS 2012 |
| CU4 | 1213285 | 2820918 | FIX: PowerPivot database is not deleted from SSAS memory when PowerPivot database processing fails |
| CU4 | 1226964 | 2821836 | FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2 |
| CU4 | 1232408 | 2831472 | FIX: Incorrect value is returned when you run an UPDATE CUBE statement in SSAS 2012 |
| CU4 | 1232425 | 2831478 | FIX: Incorrect result or access violation when you run an MDX query against an SSAS 2012 database that has multiple data sources |
| CU4 | 1267972 | 2843467 | FIX: "Internal error" when you run an MDX query after you run an UPDATE CUBE statement in SSAS 2012 |
| CU4 | 1274132 | 2845166 | FIX: You receive a file system error message when you try to save modifications in SSAS 2012 by using SSDT |
| CU4 | 1079200 | 2770635 | FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources |
| CU3 | 1155742 | 2761400 | FIX: An incomplete data import is reported as successful after a time-out in SSAS 2008 R2 or in SSAS 2012 |
| CU3 | 1169524 | 2770635 | FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources |
| CU3 | 1207361 | 2794260 | FIX: Session deadlock occurs when you use an Analysis Services personalization extension in SSAS 2008 R2 or in SSAS 2012 |
| CU3 | 1201575 | 2800842 | FIX: Performance improvement for the MDX query designer in SQL Server 2012 PowerPivot for Excel |
| CU3 | 1167499 | 2801889 | FIX: You cannot open a PowerPivot workbook after you install SQL Server 2012 SP1 PowerPivot for Excel |
| CU3 | 1171274 | 2803911 | FIX: "Errors in cell writeback" message when you run UPDATE CUBE statements after you upgrade to SSAS 2012 |
| CU3 | 1175526 | 2807487 | FIX: Dimension property is not translated correctly when you query the property by using an MDX query that has the tabular format configured in SSAS 2012 |
| CU3 | 1150340 | 2809127 | FIX: Error when you edit the connection string in Analysis Services Deployment Wizard tool after you apply SQL Server 2012 SP1 |
| CU3 | 1207367 | 2809339 | FIX: High memory usage or OOM error when you run an MDX query in SSAS 2008 R2 or in SSAS 2012 that uses the INT function |
| CU3 | 1201572 | 2811607 | FIX: MDX query returns no results when a row-level security user runs an MDX query in SQL Server 2012 |
| CU3 | 1201432 | 2821686 | FIX: SSAS 2012 freezes when a scheduled data update starts while you run complex DAX queries |
| CU3 | 1182790 | 2823086 | FIX: "The MDX function failed because the coordinate for the 'AttributeName' attribute contains a set." message when you run an MDX query in SQL Server 2012 |
| CU3 | 1207377 | 2809431 | FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 |
| CU2 | 1034257 | 2748780 | FIX: Calculated measures are changed after you browse a cube in SSAS 2012 |
| CU2 | 1080492 | 2762102 | FIX: Incorrect result when you run an MDX query that has an Aggregate function in SSAS 2008 R2 or in SSAS 2012 |
| CU2 | 1154933 | 2776947 | FIX: Incorrect result in a calculated column when the column contains an expression that resembles "ISBLANK(RELATED())" in SSAS 2012 |
| CU2 | 1154937 | 2778200 | A hotfix is available that improves performance for an MDX query that uses the "NON EMPTY" operation together with overlapping calculations in SQL Server 2012 Analysis Services |
| CU2 | 1154931 | 2779898 | FIX: Error messages when you impersonate another user and run an MDX query in SSAS 2012 |
| CU2 | 1122125 | 2781126 | FIX: W3wp.exe exceptions and SharePoint farm becomes unavailable after you disable a data refresh schedule for a PowerPivot workbook in SharePoint 2013 that interacts with SSAS 2012 |
| CU1 | 1086784 | 2406666 | FIX: "[Teradata Database] [3737]" error when you click "Count" in the Aggregation Design Wizard in SSAS 2008, in SSAS 2012 or in SSAS 2008 R2 |
| CU1 | 1086773 | 2731068 | FIX: "An unexpected error occurred" when you query some calculation data of an SSAS tabular model by using SQL Server 2008 R2 PowerPivot for Excel 2010 or SQL Server 2008 R2 PowerPivot for SharePoint 2010 |
| CU1 | 1078575 | 2737580 | FIX: Internal error when you execute queries against a non-rectangular mining model by using DMX or MDX in SQL Server 2012 Analysis Services |