SQL Server 2016 CTP New Features - 3rd March 21:53

0. Contents

3. Analysis Services

3.1 New elements in MS-CSDLBI 2.0 schema (CTP 1.0)

3.2 Easier setup for Analysis Services Power Pivot Mode (CTP 1.0)

3.3 Add Computer Accounts as Administrators in Management Studio (CTP 2.0)

3.4 Parallel processing for multiple table partitions in Tabular models (CTP 2.0)

3.5 New DAX Functions for Tabular models

3.5.1 Date and Time Functions (CTP 2.3)

3.5.2 Filter Functions (CTP 2.3)

3.5.3 Information Functions (CTP 2.3)

3.5.4 Math and Trig Functions (CTP 2.3)

3.5.5 Statistical Functions (CTP 2.3)

3.5.6 Text Functions (CTP 2.3)

3.5.7 Other Functions (CTP 2.3)

3.6 Improved query generation for DirectQuery (CTP 2.3)

3.7 New behaviors for DAX variables (CTP 2.3)

3.8 Extended Events updates (CTP 2.3)

3.8 DBCC for Analysis Services (CTP 3.0)

3.9 Analysis Services Management Objects (AMO) updates (CTP 3.0)

3.10 Administration of Tabular 1200 models in SSMS (CTP 3.0)

3.11 Support for Visual Studio Configuration manager (CTP 3.0)

3.12 Saving incomplete measures (CTP 3.0)

3.13 Formula Fixup (CTP 3.0)

3.14 Improved SSDT modeling performance for Tabular 1200 models (CTP 3.0)

3.15 Improved DAX formula editing (CTP 3.0)

3.16 Project templates added for Tabular 1200 models in SSDT (CTP 3.0)

3.17 New data sources for DirectQuery mode (CTP 3.0)

3.18 Partition management for Tabular 1200 models in SSMS (CTP 3.1)

3.19 Upgrade, roles, and metadata visualization for Tabular 1200 models in SSDT (CTP 3.1)

3.20 Set default for bi-directional cross filters in tabular models in SSDT (CTP 3.2)

3.21 New DirectQuery implementation (CTP 3.2)

3.22 Calculated tables in SSDT (CTP 3.2)

3.22 Tabular Model Scripting Language (TMSL) supported in SSMS (CTP 3.2)

3.23 Enable/disable attribute hierarchies ??