Create Tabular Model in SSAS 2016

Leave a comment

We will go through an example of how to create a new tabular model in SQL Server Analysis Services 2016 (SSAS).

Open SQL Server Data Tools (SSDT) and create a new Analysis Services Tabular project:

 

A new project will be created:

Model.bim contains the following properties:

Add data source connection:

Connect to SQL data warehouse:

To add tables to the model, click Model->Existing Connections:

Open:

Mark the date table as date table:

Change the view to Diagram View and see the table relationships:

Add a new column Extended Price and type the formula:

Create a new measure and add a DAX formula:

Build and save the solution.

In SSAS, you will now see the new database:

 

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

11 − three =