Jan 20, 2017 - Microsoft released CU1 for SQL Server 2016 SP1

Written by Vidas Matelis. Posted in SSAS News

On Jan 20, 2017 Microsoft released Cumulative Update package 1 (CU1) fro Service Pack 1 (SP1) for SQL Server 2016

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012 Service Pack 1. This build number of this cumulative update package is 13.0.4411.0.

List of fixes related to SQL Server Analysis Services / Powerpivot 2012 (since SP1):

VSTS bug number	KB article number	Description
8198025	3025408	FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS
9100068	3211605	FIX: Error occurs for queries on global measures that have previously been referenced by query scoped measures in SSAS 2016 tabular mode
9097248	3198827	FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members
9099937	3208178	FIX: Access violation when invalid credentials or connection string is specified in SQL Server 2016 Analysis Services
9100139	3212541	FIX: SSAS may crash when a numeric calculated column must change its encoding scheme during the ProcessRecalc phase
9100261	3198356	FIX: Error when you execute an MDX query on a Tabular model database in SQL Server 2016 Analysis Services
9097256	3198826	FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services
8986617	3209520	FIX: SSAS stored connection strings become corrupted if extended properties are used incorrectly
8808992	3209426	FIX: Processing a partition in SSAS 2016 drops all data from other partitions that are in the "incomplete" state
9098036	3206912	FIX: Credential settings are lost when you schedule data refresh for PowerPivot workbooks
9078847	3213709	FIX: The SAMEPERIODLASTYEAR function does not work in DAX queries in SQL Server 2016 Analysis Services
9098040	3212916	FIX: SSAS may crash on query execution if a predefined role is specified in the connection string
9097254	3183686	FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS

Tags: news