May 18, 2015 - Microsoft released SP1 for SQL Server 2014
On May 18, 2015 Microsoft released Service Pack 1 (SP1) for SQL Server 2014.
This service pack contains up to and including SQL Server 2014 RTM Cumulative Update 5 (CU5). This build number of this cumulative update package is 12.0.4100.1.
List of fixes related to SQL Server Analysis Services / PowerPivot 2014:
|
Release |
SQL Bug Number |
KB Article Number |
Description |
| SP1 | 2580628 | 2965035 | SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2 |
| SP1 | 2581225 | 2964762 | FIX: Event ID 22 or error 0xC1000016 will be logged when you use the Discover command in SSAS 2012 |
| SP1 | 2581317 | 2963382 | FIX: Can't connect to the server when you run a cube creation MDX query in SSAS 2012 or SSAS 2014 |
| 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 |