Time for action – creating an Analysis Services project

In this example and other examples of this book, we will use SSDT for Visual Studio 2012. You can download and install it from http://www.microsoft.com/en-us/download/details.aspx?id=36843.

After installation, perform the following steps:

  1. Open SQL Server Data Tools by clicking on Start, then navigate to your Microsoft SQL Server 2012 folder and under that, choose SQL Server Data Tools for Visual Studio 2012.
  2. Go to the File menu and under New, select Project.
  3. In the New Project window, under templates in the left-hand side pane, click on Analysis Services and from the list of templates in the main pane, choose Analysis Services Multidimensional and Data Mining Project. Name the project Chapter ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial