Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 02 SSAS Multidimensional, as shown in the following screenshot:

What just happened?

In this example, we used SQL Server Data Tools to create our first Analysis Services project. After creating the project, you will see an empty project with folders...