560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This blog shows how to create your first tabular project in Visual Studio
Part four of a four-part series of blogs
Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.
Once you've gone into Visual Studio (and customised it to show Solution Explorer and the Properties window), you can create a project as shown below.
You can choose to create a new project using this menu option:
You can press SHIFT + CTRL + N to do this too.
You can now choose to create a new tabular model project, and also choose where to put it:
Choose to create an Analysis Services BI project (and an Analysis Services Tabular Project to be specific).
Note that in the above dialog box, there's little point creating a directory for your solution:
If you tick this box, you just get an additional unwelcome folder in your hierarchy.
A solution allows you to view more than one project simultaneously, but for most Visual Studio developers it will be sufficient to have a single project open at a time.
You may now be prompted to choose your workspace server:
The workspace server is the Analysis Services instance which will contain any models that you create. It may be an idea to tick Do not show this message again, as you'll always want to use the SSAS instance running on your computer!
You can now see your project in Solution Explorer:
The files created for the project.
Every tabular project contains one (and only one) model, so there's not much left to do at this stage in Solution Explorer:
You can double-click on the Model.bim file to see your model (which to begin with will be completely blank).
Time now to go to the next part of this tutorial: a walk-through of creating a basic model.
|Parts of this blog|
25 Aytoun Street