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





Comments For This Article





download


Recommended Reading

Troubleshooting Common SQL Server Analysis Services Connectivity Issues

SQL Server Analysis Services SSAS Hardware Configuration Recommendations

SQL Server Analysis Services Cube Processing Status Report

How to change compatibility level of a SSAS Tabular Database using SSDT

How to restore a SQL Server Analysis Services Database





get free sql tips
agree to terms


Learn more about SQL Server tools