Today is a great day. I have been able to take part in the #MSDataAmp conference. While listening to Scott Guthrie I found that SQL Server 2017 CTP 2.0 is available for download
I like to way Microsoft changes the Analysis Services engine over the time. I just had opportunity to take a look what the engine offered in 2012 and to see how it has been changed since then is very impressive
Here is what is new / changed / enhanced in the SQL Server 2017 CTP 2.0 in the SSAS engine (text copied from the Analysis Services Team Blog)
The public CTP 2.0 of SQL Server 2017 on Windows is available here! This public preview includes the following enhancements for Analysis Services tabular.
- Object-level security to secure model metadata in addition to data.
- Transaction-performance improvements for a more responsive developer experience.
- Dynamic Management View improvements for 1200 and 1400 models enabling dependency analysis and reporting.
- Improvements to the authoring experience of detail rows expressions.
- Hierarchy and column reuse to be surfaced in more helpful locations in the Power BI field list.
- Date relationships to easily create relationships to date dimensions based on date columns.
- Default installation option for Analysis Services is tabular, not multidimensional.
Other enhancements not covered by this post include the following.
- New Power Query data sources. See this post for more info.
- DAX Editor for SSDT. See this post for more info.
- Existing Direct Query data sources support for M expressions. See this post for more info.
- SSMS improvements, such as viewing, editing, and scripting support for structured data sources.
The complete blog post is here: http://bit.ly/2pCwMMo