10 May’17

BIDeveloping 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.


Written by

Sachin Dabre

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more