Tuesday, June 28, 2016

SSAS Tabular Part 1: Create a New Tabular Model Project

To create a new tabular model project in SSDT 2012

1.       Open SQL Server Data Tools 2012.


2.       Click On NEW Project.


3.    In the New Project dialog box, under Installed Templates, click Business Intelligence, then click Analysis Services, and then click Analysis Services Tabular Project.


4.       In Name, type your project name, then specify a location for the project files.
By default, Solution Name will be the same as the project name; however, you can type a different solution name.
5.     Click OK.
6.    In the Tabular model designer dialog box, in Workspace server, type the name of a SQL Server 2012 Analysis Services instance where you have Server Administrator permissions, and then click Test Connection.



7.       Your Tabular Project is Created with Model.bim


No comments:

Post a Comment