Developing and Deploying an OLAP Cube

In this blog article, I will explain you how to develop and deploy an OLAP Cube. This article is help to learn creation of OLAP Cube in SSAS.

An OLAP cube is a technology that stores data in an optimized way to provide a quick response to various types of complex queries by using dimensions and measures.

Step 1: Start Analysis Project

Click on File -> New -> Project -> Business Intelligence -> Select Analysis Service -> Analysis Services Multidimensional and Data Mining -> specify name for the project -> click Ok.

Step 2: Creating Data Source

In Solution Explorer, right click on Data Source -> Click on New Data Source -> click Next -> click on New button.

For Creating a new connection:

1)  Specify Your SQL Server Name

2)  Select the log on option

3)  Select the database name from the server

Then click on Next -> Next -> Assign name for Data Source  -> Finish.

Step 3: Creating Data Source View

In the Solution Explorer, Right Click on Data Source View -> Click on New Data Source View -> Select Relational Data Source which we have created in Step 2. -> Click on Next.

First move your Fact Table to the right side to include in object list.

Select Fact Table in Right Pane (Fact product Sales) -> Click On Add Related Tables

Then click on Next -> Finish

Data Source View is ready.

Step 4: Creating New Cube

In Solution Explorer -> Right Click on Cube-> Click New Cube -> Click on Next -> click on Use existing tables -> Next.

Select Fact Table Name from Measure Group Tables -> Click Next.

Choose Measures from the List which you want to place in your Cube -> Click Next

Then click Next -> Next -> Assign Cube name -> Finish.

Your Cube is ready and you can see the newly created Cube and dimensions added in solution explorer.

Step 5: Deploy the Cube

In Solution Explorer, right click on Project Name -> Click Properties.

Specify the target Server name and server mode.

In Solution Explorer, right click on Project Name -> Click Deploy

Once Deployment will finish, you can see the message Deployment Completed in deployment Properties.