Improvement: IsAvailableInMDX feature can disable processing for specific columns in TREATAS function DAX query in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Improvement


Assume that you use SQL Server 2017 AnalysisService (SSAS 2017).  TREATASfunction Data Analysis Expressions (DAX) query does not work when the columns it uses are not processed. This improvement adds a new feature IsAvailableInMDX that candisable processing for specific columns to make sure that TREATAS function DAX query work in such columns.

Note The performance will be lowered a bit when you run the query with this feature.

Resolution


This improvement is included in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

References


Learn about the terminology that Microsoft uses to describe software updates.