Dec 18, 2014 - Microsoft released CU5 for SQL Server 2014
On Dec 18, 2014 Microsoft released Cumulative Update Package 5 (CU5) for SQL Server 2014.
This update contains hotfixes for issues that were fixed after the release of SQL Server 2014. This build number of this cumulative update package is 12.0.2456.0.
List of fixes related to SQL Server Analysis Services / PowerPivot 2014:
| Release | SQL Bug Number | KB Article Number | Description |
| CU5 | 3720664 | 2981424 | FIX: Exception when you select more than one hierarchy from parent/child dimension in SSAS 2012 or in SSAS 2014 |
| CU5 | 3260606 | 2992069 | FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 or SSAS 2014 processing |
| CU5 | 3720635 | 2998870 | FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014 |
| CU5 | 3428568 | 3016518 | FIX: "You do not have permission." error when you run a report that connects to a .BISM file in PowerPivot gallery |
| CU4 | 2906084 | 2963137 | FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012 or SSAS 2014 |
| CU4 | 2906101 | 2965922 | FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013 |
| CU4 | 2906091 | 2975385 | FIX: User obtains incorrect data when two users in the same security role run a client report in SSAS 2012 or SSAS 2014 |
| CU4 | 3260588 | 2975743 | FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS |
| CU4 | 2906151 | 2976172 | FIX: An access violation occurs when you perform Process Data or Process Full on a partition in a table in SSAS |
| CU4 | 2906149 | 2976861 | FIX: The time is longer and longer to perform process full on an SSAS 2012 or SSAS 2014 tabular model database |
| CU4 | 2906115 | 2976953 | FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012 or in SSAS 2014 |
| CU4 | 3260578 | 2989512 | FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model |
| CU4 | 3260603 | 2989590 | FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS |
| CU4 | 3260618 | 2993483 | FIX: SSAS processing fails when you perform a Process Full operation on many partitions in a transaction |
| CU4 | 2976564 | 2999308 | Add detailed information to the "Call to Excel Services returned an error" error message in SQL Server 2014 PowerPivot |
| CU3 | 2578302 | 2961559 | FIX: Incorrect folder when deploying SQL Server 2012 or SQL Server 2014 PowerPivot solutions by using SharePoint 2013 Central Admin |
| CU3 | 2578304 | 2963372 | FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 or SSAS 2014 |
| CU3 | 2515653 | 2975434 | FIX: Error when you complete an SSAS 2014 image after specifying a non-default root directory |
| CU3 | 2895169 | 2989715 | FIX: Dimension attribute is lost in Excel PivotTable Field List when you set AttributeHierarchyDisplayFolder to "" in SSDT-BI |
| CU2 | 2525268 | 2932559 | FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014 |
| CU2 | 2525270 | 2954480 | FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined |
| CU2 | 2525290 | 2961254 | FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2 |
| CU2 | 2525299 | 2962650 | FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014 |
| CU2 | 2593575 | 2967900 | FIX: Data models do not load after you run a PowerPivot scheduled data refresh job when you work with SQL Server 2014 |
| CU2 | 2262840 | 2968974 | FIX: You cannot create a power view report against a UDM cube in SSAS 2014 |
| CU2 | 2262877 | 2974373 | FIX: Poor performance when you use DAX functions on a String or Boolean column in SSAS 2014 |
| CU2 | 2361316 | 2962599 | Can now disable checking whether dimension and partition data originate from the same data source when you run a ROLAP query in SQL Server 2014 |
| CU1 | 2034093 | 2860446 | FIX: Unexpected error in "XMCompressionAnalyzer::SelectBitPackCompression" function when you perform a Process command against a partitioned table in SSAS 2012 or SSAS 2014 |
| CU1 | 2034099 | 2864111 | FIX: It takes longer than expected to cancel an MDX query that contains many GROUP BY clauses in SSAS 2012 or SSAS 2014 |
| CU1 | 1993317 | 2864930 | FIX: You cannot write text that has more than 32,767 characters in Report Query Designer in SQL Server |
| CU1 | 2034115 | 2872946 | FIX: CPU spinning occurs when you use Power View to run a DAX query against a Multidimensional model in SSAS 2012 or SSAS 2014 |
| CU1 | 2034128 | 2876882 | FIX: "Internal error: An unexpected error occurred" when you run a "Process" command against the TFS SSAS cube |
| CU1 | 2066169 | 2880071 | FIX: Error messages when you perform a ProcessRecalc operation after a ProcessData operation on an SSAS 2012 or SSAS 2014 tabular model |
| CU1 | 2034081 | 2880094 | FIX: Grand total or subtotal rows display incorrect results in a Power View report that runs against a multidimensional cube in SSAS 2012 or SSAS 2014 |
| CU1 | 2034109 | 2884124 | FIX: "Type mismatch" error when you run an MDX query that uses the Member.Name property against an SSAS 2012 or SSAS 2014 database |
| CU1 | 2033406 | 2890415 | Notification messages of data update failure are not sent when you use the PowerPivot for SharePoint 2013 add-in for SQL Server 2012 SP1 or SQL Server 2014 |
| CU1 | 1993318 | 2890818 | FIX: Incorrect value is returned when you run an UPDATE CUBE statement that uses the USE_WEIGHTED_INCREMENT allocation method in SSAS |
| CU1 | 1852105 | 2895694 | FIX: Query scope assignment works incorrectly after you run a ClearCache command in SSAS |
| CU1 | 1993316 | 2896903 | FIX: You cannot perform any administrator actions on databases when a data model corruption occurs in SSAS 2012 or SSAS 2014 |
| CU1 | 2033273 | 2897263 | "An error occurred when loading VertiPaq data" message after you load a database in SSAS 2012 or SSAS 2014 |
| CU1 | 2033667 | 2897265 | FIX: "Invalid column name" error when you run some MDX queries against ROLAP partitions in SSAS 2012 or SSAS 2014 |
| CU1 | 2033721 | 2897282 | FIX: Wrong date format will be returned when you run DateAdd or Day function in SSAS 2012 or SSAS 2014 on a non-US locale computer |
| CU1 | 2033617 | 2905275 | FIX: Error messages when you run some MDX or DAX queries in SSAS 2012 or SSAS 2014 |
| CU1 | 2033300 | 2905298 | FIX: It takes much longer for a user without administrator permissions to run an MDX query than an administrator user in SSAS 2012 or SSAS 2014 |
| CU1 | 2034911 | 2912928 | FIX: SQL Server 2012 or SQL Server 2014 PowerPivot for SharePoint 2010 cannot create databases when the SharePoint server name is FQDN |
| CU1 | 1852113 | 2912949 | FIX: SSAS crashes when more than one thread tries to access an SSAS cube at the same time |
| CU1 | 1993315 | 2921630 | FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS |
| CU1 | 2205355 | 2927524 | FIX: MDX query does not reuse cache after clear cache command on different Measure Group with Non-Admin login in SSAS 2012 or SSAS 2014 |
| CU1 | 2101350 | 2927748 | FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7 or in SQL Server 2014 |
| CU1 | 2205357 | 2927844 | FIX: Large DistinctCount become slower in tabular mode in SQL Server 2012 or SQL Server 2014 |
| CU1 | 2076865 | 2922799 | FIX: Unexpected exception is thrown when you convert writeback partition in SSAS |