Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Create Project from a Deployed SSAS Tabular Database


By:   |   Updated: 2016-09-23   |   Comments   |   Related: > Analysis Services Administration

Problem

You need to create project files for a SQL Server Analysis Services (SSAS) tabular database deployed on a SSAS Tabular Instance, but you don't have access to the project source for some reason. Creating an entire project from scratch that reflects the deployed database is not an option, so in this tip we will learn how to handle this situation.

Solution

We will walk through the steps to create project files for a SSAS database deployed on a SSAS Tabular instance.

For the purpose of this demonstration, I have installed the AdventureWorks Tabular 2014 Database on my machine. Follow the below steps to create a project from this database using SSDT.

 

Step 1: Open the SQL Server Data Tools (SSDT), and select the menu option "File" > "New" > "Project". Select Import from Server (Tabular) option as shown below and click OK.

New Project in SQL Server Data Tools

 

Step 2: The next step is to select the Analysis Server that will be used by the new project. You can type the name of the server or in the case where you have SSAS installed locally, you can type localhost as shown below.

select the SQL Server Analysis Server that will be used by the new project

 

Step 3: The next step is to select the Analysis Server on which the database is hosted, and the database name which you intend to import the project structure. Select the same as shown below and click OK.

SQL Server Analysis Server on which the database is hosted, and the database name which you intend to import the project structure

 

Step 4: The above step will create the structure, but it will not have any data. In order to retrieve data into the model we need to process the structure. To ensure that we have connectivity to the source from which the SSAS database is sourcing data, click on the menu option "Model" > "Existing Connections". Make sure you are able to connect to the data source of the SSAS database as well as the Impersonation Settings are configured with credentials that have sufficient privileges to process the data.

 
Import the data for the SQL Server Analysis Services Tabular Database

 

Step 5: In order to process the data, select the menu option "Model" > "Process" > "Process All". This will bring up a dialog box that will show the processing progress. Once the processing is complete, you should be able to see results similar to below.

Process All Data for the SQL Server Analysis Services Tabular Database

 

Step 6: Post processing when you open the model in data view, you should be able to find data in the designer.

Review the imported data

In this way one can create an entire new project from a deployed SSAS Tabular database.

Next Steps
  • Try to ensure that the project deployment configuration settings match the deployed database, in order to modify the database during deployment instead of creating a new database.
  • Read more Analysis Services Tips


Last Updated: 2016-09-23


get scripts

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.



    



Learn more about SQL Server tools