x

When configuring the Adapter for SQL Server Analysis Services (SSAS), you can now customize the connection name.

x

SQL Server Analysis Services Version 2012 is now supported in both MDX and Tabular modes.

x

The Adapter for SQL Server Analysis Services now supports both the traditional SQL Server 2012 Analysis Services Multidimensional Model and the new Tabular Model.

There are actually three different approaches for creating a business intelligence semantic model provided by the latest SQL Server 2012 Analysis Services:

• Tabular.
• Multidimensional.
• PowerPivot.

Tabular solutions use relational modeling constructs, such as tables and relationships, for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data.

The concepts involved in designing the two types of models (Tabular and MDX) are very different. You cannot convert a Tabular database into or out of a Multidimensional database without totally rebuilding it.

Queries and calculations in the Tabular model are defined in Data Analysis eXpressions (DAX), the native language of the Tabular model, which is not supported in the Multidimensional model.

x

The Adapter for SQL Server Analysis Services can now generate the TOPCOUNT and BOTTOMCOUNT for the reports that have both:

1. BY [HIGHEST/LOWEST] TOTAL <measure field>

2. IF READLIMIT n

x

The Adapter for SQL Server Analysis Services can now generate Master File field names for dimension elements based on the concatenation of dimension, hierarchy, level, and property captions. This feature is implemented by selecting Generate Qualified Field Names on the Web Console Create Synonym page.

For levels of standard hierarchies, the field names are generated based on the concatenated dimension, hierarchy, and level captions. Some hierarchy captions in SSAS are already qualified with a dimension name (when multiple cube dimensions are based on one database dimension). The synonym created in this case avoids double qualification.

Field names for user-defined properties of standard hierarchies are created based on the concatenated dimension, hierarchy, level, and property captions. For attribute hierarchies (that always contain a single-level with a caption identical to the hierarchy caption), the level caption is based on the concatenated dimension and hierarchy captions.

For parent/child hierarchies, the names of mandatory properties fields are created based on the concatenated dimension and hierarchy captions. Field names for user-defined properties are created based on the concatenated dimension, hierarchy, and property captions.

x

The Adapter for SQL Server Analysis Services now has the ability to use multiple field restrictions connected with the AND operator within a DBA security statement in the Master FIle for SSAS cubes.