bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

SSAS : OLAP CUBE

It is a Microsoft Business intelligence tool to creating Online analytical processing and data mining functionality. We can create an OLAP (online analytical processing)  cube using SQl server analysis system.

Key Features of SSAS:

  • Ease of use with many wizards and designers
  • Data model creation and management is flexible
  • OLAP handling from scalable architecture
  • Customize application from extensive support

Looking for top jobs in Business Intelligence ? This blog post gives you all the information you need!

Why do we use SSAS:

1.Speed

2.Shared metadata

3.Security

4.Multidimensional analysis

5.Avoid resource contention with the source system

6.Consolidate from multiple sources

What are OLAP  Cube?uses of OLAP Cube.

msbi1

It is a technology that stores the data in optimized way to easily fetched from different types of complex queries by using various measures and dimensions. We can develop the OLAP cube  using the BIDS (business intelligence  development studio)

Follow the below steps to run the query in SSMS (SQL Server management studio)

  1. Open SSMS 2008
  2. Connect the database engine
  3. Open new query editor
  4. Paste the SQL script here
  5. Press F5 to run the script
  6. It will create and populate “Sales_DW” database.

OLAP Cube developing:

Step 1: Start Business intelligence development studio environment.

Start menu –> Microsoft SQL Server 2008 R2  –>Select SQL Server BIDS

msbi1

Step 2: Start analysis services project:SSAS can create and occupy  a physical table in the data source it will use to occupy the dimension maintained in the SSAS databases ,On the specify source information.

 File–> New –> Project –> Business Intelligence projects –> select Analysis service project –> give  project name –> Click OK .

msbi1

Step 3: Creating New data source

Right click on Data source –> Click  New Data Source

msbi1

Click on next new button.Create the new connection

  •  Select the SQL server name  where we created the data warehouse
  • Select server authentication mode
  •  Enter your username and password  to connect SQL Serve
  • Select database Sales_DW
  • Test connection –> OK.

msbi1

Select Connection created in Data connections –>next –> select option Inherit –> next –> assign data source name –> finish

msbi1

Step 4: Creating New data source view: We create a data source view (DSV) as an abstraction of the tables from the data source. In solution Explorer, right click on the Data Source view then click new data source view to create the  new one data source view,after that click on next and select relational data source then next.

Right click on Data Source view –> New data Source view –> next –> Select Relational data source which we have created previously i.e., Sales_DW –> next

msbi1

shift Fact Table from available objects to Included objects

msbi1

Select FactProductSales  –> Add related tables –> next –> next –> Assign Name  (SalesDW DSV)  –> Finish

Now data Source view is ready to use.

msbi1

Step 5: Creating New Cube

In solution Explorer –> Cube (Right click) –> New cube –> Next –>.Select Use existing  tables –> Next –> FactProductSites –> Next –>Choose measure–>Next –> Select all the  Check box in select new dimensions –>Next –> Assign cube name –> Finish.

Now Cube is ready

msbi1

Step 6: In Solution Explorer, Click on dimension DimProduct à drag and drop the product name

msbi1

Step 7 :Deploy the Cube

In the Solution Explorer, right click on project name –> properties –> In configuration properties, Select Deployment –> Assign  SQL Server Instance Name –> Deploy All –> Do not process –> OK.

Right click on Project Name –> Click Deploy

We can see the  message Deployment Completed in properties

msbi1

Step 8: Process the Cube : Right click on Project Name –> Process

msbi1

Click on Run to process the cube after completing the process , we can see the status as process succeed –>close .

Step 9: Browse the cube for analysis

Right click on the  cube name à browse

Follow the steps to browse our cube

  1. Product Name Drag & Drop into Column
  2. Full Date UK Drag & Drop into Row Field
  3. FactProductSalesCount drag and drop this measure in Detail field

msbi1

 

"0 Responses on SSAS : OLAP CUBE"

Leave a Message

Your email address will not be published.

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

top

Sales Offer

  • To avail this offer, enroll before 05th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free SSAS : OLAP CUBE.