Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Port SQL Server Analysis Services Tabular Databases to SSAS vNext CTP 1.1


By:   |   Last Updated: 2017-01-17   |   Comments (1)   |   Related Tips: > Analysis Services Development

Problem

SQL Server vNext CTP 1.1 has been released. This CTP has some interesting enhancements for SSAS Tabular. In order to try these enhancements, one may want to port their existing SSAS solutions or create a new SSAS solution in the SSAS vNext. In this tip we look at how to achieve this.

Solution

SQL Server Data Tools (SSDT) provides options to set the compatibility level of SSAS vNext.

In order for a SSAS Tabular solution to have access to any given features on a SSAS edition, it's compatibility level needs to be set. The compatibility level of SSAS vNext is 1400. So SSAS Tabular solutions that intend to access the features of SSAS vNext should set their compatibility level to 1400. Let's take a look at how this can be achieved.

  1. Download and install SSAS vNext CTP 1.1 using the SQL Server vNext CTP 1.1 setup, which can be downloaded from here.
  2. SSDT 17.0 RC1 is required to work with SSAS vNext CTP 1.1 as it contains the needed support. Download and install from here.
  3. After the installation is complete, select the File > New > Project menu option and you should be able to find the SSAS project options as shown below. In case you opt to create a brand new SSAS Tabular project, the compatibility level of your project should be set to 1400 by default, which is the compatibility level of SSAS vNext. In case you want to change the compatibility of any of your existing solutions, you may want to import from the server where it may have been hosted. For this select the "Import from Server (Tabular)" option.
  4. New Analysis Services Tabular Project


  5. Once you have opted to import the project from a SSAS Tabular Server, you will be prompted to select the compatibility level and the workspace server for the new project. You can select the compatibility level here as 1400 as shown below. The choice of the workspace server affects the compatibility options available for the solution. If you select a SSAS server other than SSAS vNext as your workspace server, you many not find the 1400 compatibility level listed for your solution.


  6. SQL Server Analysis Services Tabular Model Designer


  7. Finally, if you have hosted a solution with a lower compatibility level on SSAS vNext, you can still edit the model properties, and select the 1400 compatibility level and re-process and/or re-deploy the solution to upgrade the compatibility level.
Set the compatibility level 1400

Once the compatibility level of your new or existing SSAS Tabular project is changed to 1400 using methods supported by SSAS Tabular vNext, your solution should have access to all the new features of SSAS vNext.

Next Steps
  • Try the above mentioned steps to test the compatibility level of SSAS Tabular vNext on your SSAS Tabular solutions.


Last Updated: 2017-01-17


next webcast button


next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Sunday, March 05, 2017 - 8:58:45 AM - Vivek Back To Top

 

 Do I need to install SQL Server vNext as well for using SSAS vNext or can I just install just SSAS vNext?


Learn more about SQL Server tools