Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
What's New in Analysis Services

What's New in Analysis Services

 

SQL Server 2016 Analysis Services (SSAS) includes the following feature updates.

[CTP 2.0] 

SQL Server 2016 Analysis Services (SSAS) includes new parallel processing functionality for tables with two or more partitions, increasing processing performance. There are no configuration settings for this feature. For more information about configuring partitions and processing tables, see Tabular Model Partitions (SSAS Tabular).

[CTP 2.0] 

Analysis Services administrators can now use SQL Server Management Studio to configure computer accounts to be members of the Analysis Services administrators group. In the Select Users or Groups dialog, set the Locations for the computers domain and then add the Computers object type. For more information, see Configure Analysis Services Server Administrators.

[CTP 2.0] 

The new DBCC XMLA command checks for physical and logical data corruption in both tabular and multidimensional databases, offering fast and efficient diagnosis of the more common forms of data corruption. For more information, see Database Consistency Checker (DBCC) for Analysis Services tabular and multidimensional databases.

[CTP 1.0] 

Installation of Power Pivot for SharePoint is simplified. You select Analysis Services from the standard Instance Feature list and then from a single setup page you select the Analysis Services server mode and configure administrators.

select analysis services server mode

For more information, see Install Power Pivot for SharePoint 2013.

[CTP 1.0] 

SQL Server 2016 Analysis Services (SSAS) includes the following new DAX functions.

Function

Description

ADDMISSINGITEMS

Adds combinations of items from multiple columns to a table if they do not already exist. The determination of which item combinations to add is based on referencing source columns which contain all the possible values for the columns.

CALENDAR

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.

CALENDARAUTO

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.

CONCATENATEX

Concatenates the result of an expression evaluated for each row in a table.

DATEDIFF

Specifies the cross-filtering direction to be used in a calculation for a relationship that exists between two columns.

GEOMEAN

Returns the geometric mean of the numbers in a column.

GEOMEANX

Returns the geometric mean of an expression evaluated for each row in a table.

GROUPBY

Returns the binary data returned from a URL.

ISEMPTY

Checks if a table is empty.

ISONORAFTER

A boolean function that emulates the behavior of a ‘Start At’ clause and returns true for a row that meets all of the condition parameters.

MEDIAN

Returns the median of numbers in a column.

MEDIANX

Returns the median number of an expression evaluated for each row in a table.

NATURALINNERJOIN

Performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. If the two tables have no common column names, an error is returned.

NATURALLEFTOUTERJOIN

Performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. If the two tables have no common column names, an error is returned.

PERCENTILE.EXC

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

PERCENTILE.INC

Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.

PERCENTILEX.EXC

Returns the percentile number of an expression evaluated for each row in a table.

PERCENTILEX.INC

Returns the percentile number of an expression evaluated for each row in a table.

PRODUCT

Returns the product of the numbers in a column.

PRODUCTX

Returns the product of an expression evaluated for each row in a table.

SUBSTITUTEWITHINDEX

Returns a table which represents a left semijoin of the two tables supplied as arguments. The semijoin is performed by using common columns, determined by common column names and common data type . The columns being joined on are replaced with a single column in the returned table which is of type integer and contains an index. The index is a reference into the right join table given a specified sort order.

Columns in the right/second table supplied which do not exist in the left/first table supplied are not included in the returned table and are not used to join on.

The index starts at 0 (0-based) and is incremented by one for each additional row in the right/second join table supplied. The index is based on the sort order specified for the right/second join table.

SUMMARIZECOLUMNS

Returns a summary table over a set of groups.

UNION

Creates a union (join) table from a pair of tables.

XIRR

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

XNPV

Returns the present value for a schedule of cash flows that is not necessarily periodic.

The following existing functions received updates for this release.

Function

Description

TOPn

Now allows TRUE/FALSE/ASC/DESC to specify sorting direction.

[CTP 1.0] 

The following elements have been added to the TProperty complex type defined in the [MS-CSDLBI] 2.0 schema:

Element

Definition

DefaultValue

A property that specifies the value used when evaluating the query. The DefaultValue property is optional, but it is automatically selected if the values from the member cannot be aggregated.

Statistics

A set of statistics from the underlying data that is associated with the column. These statistics are defined by the TPropertyStatistics complex type and are provided only if they are not computationally expensive to generate, as described in section 2.1.13.5 of the Conceptual Schema Definition File Format with Business Intelligence Annotations document.

Community Additions

ADD
Show:
© 2015 Microsoft