BISM Normalizer: Version 3.0 Released for SSAS 2016!!!

This is a major new version of BISM Normalizer. It can be downloaded from a different Visual Studio Gallery page. It will run for free till December 31st 2016.

Visual Studio 2010/2012/2013 (SQL Server 2012/2014) are not supported by BISM Normalizer 3. For these, you can still use BISM Normalizer 2.  See the Purchase page for more info on version compatibility.

Enhancements in Version 3.0

Support for SQL Server Analysis Services 2016 and Visual Studio 2015

SSAS compatibility levels 1200, 1103 and 1100 are all supported.

JSON definitions with improved difference highlighting

Diff

Processing on database deployment

Processing

Like SSDT, processing options include “Default”, “Do Not Process” and “Full”.  There is also an option to process only the tables affected by the comparison (Create and Update), to avoid unnecessary processing.

ProcessingOptions

When deploying to a database (not project), BISM Normalizer will check connections set up for impersonation, and prompt for username and password (like deployment from SSDT).

Impersonation Credentials

Support for DirectQuery models with compatibility level 1200

Both source and target models must have the DirectQuery Mode property set to On for successful comparison.

Switch source and target in Connections dialog

Switch Connections

Improved scripting for JSON and XMLA

BISM Normalizer will use the appropriate editor if available. If not found, the option to save to a file is provided instead. Note: the JSON editor is not installed as part of a SSDT-only installation with the Visual Studio Integrated Shell.

Improved Scripting

Improved Scripting Xmla

Code behind BSMN file

View or modify contents of BSMN files.

View Code

Associate BSMN file types with Visual Studio

Open BSMN files from Windows Explorer with Visual Studio as the default application. Also display the BISM Normalizer icon in Solution Explorer. To enable this, right click a BSMN file in Solution Explorer and select the Install Solution Explorer Icon context menu. Note: administrator permissions are required to even see the menu option. This can’t be set up automatically with standard VSIX deployment from the Visual Studio Gallery because of the admin requirement.

Install Solution Explorer Icon

Advertisements