Home > Articles > SQL Server Articles > Quick questions to revise SSAS.

Quick questions to revise SSAS.

by Rahul Pyarelal   on Mar 09, 2017   Category: SQL Server  | Level: Beginner  |  Views: 1555    |  Points: 100   
Like this article? Bookmark and Share:
In this article will go through SSAS quick questions.

What is the SSAS?

SSAS(SQL Server Analysis Services) is all about analysis. Analysis on existing data, on numeric figures to predict business future by doing calculation like sum, count or same complicated formula, which does forecasting and analysis calculation. SSAS take data from database, do the all calculation and store in the SSAS database (cube). It is pre-calculation database. SSAS is software which helps you to define the pre-calculation. It runs at the background and stores the pre-calculation into a separate, SSAS database.

What is Cube in SSAS?

A cube has dimension and measures that is used to analysis on the existing available data. The measure and dimension in a cube are derived from the table. View in the data source on which is generated from the measure dimension definition.

What is Measure?

The measure term used in SSAS is also called as Fact. They are table(s) which contains business figures and by property it is numeric in nature. It is de-normalized in form. Measure or Fact are centrally located and it surrounded by Dimension. Fact and Dimension together makes Business Intelligence sensible.

Can we have multiple Measures?

Yes, in some scenarios we can have more than one fact table.

What is the Dimension?

Dimensions are generally referred to the master tables which stores the attributes which defines measures stored in the Fact table. Together they make cube which is used by SSAS for doing forecasting or prediction in business intelligence.

Why use a SSAS Cube?

  1. Cube helps to handle automatically Slowly Changing Dimensions (SCD).
  2. Best part is that it does the storing in Hierarchies.
  3. Built-in support for KPI’s (Key Performance Indicator) with which performance can be shown with better graphics.
  4. It can be used as tools, for Performance point and power view.
  5. Can be easily integrated with Excel to view data via pivot Table.
  6. Analysis Services can also be used in doing data mining.
  7. No need to join the fact and dimension tables, as this will be done in the cube.
  8. You can use the security setting to give end-users access to only those parts of the cube which are relevant to them.

What is the OLAP (Online Analytical Processing) Cube?

OLAP can be used for doing data mining. Whereas a relational database can be thought of as two-dimensional, a multi-dimension database considers each data attribute as a separate “dimension”. OLAP software can locate the intersection of dimension and display them.

  1. SSAS is the BI Tool for creating online Analytical processing and data mining functionality.
  2. SSRS Reports and Excel power pivot are used as front end for reporting and data analysis with SSAS (SQL Server Analysis Services) OLAP Cube.
  3. We have to choose OLAP Cube when performance is a key factor.

What is different between the OLAP and OTLP?

Online Transaction processing (OLTP) Online Analysis processing (OLAP)
Data store in the normalized format. Data store in the de-normalized format.
Holds daily Latest Transactional Data related to your application. Data is consistent up to the last update that occurred in your Cube.
Designed to support Daily DML Operations of your application. Designed to hold historical data for analysis and forecast business needs.
Databases size is usually around 100 MB to 100 GB. Databases size is usually around 100 GB to a few TB.

Below is a simple video on MSBI(Step by Step) :-

Like this article? Bookmark and Share:

Most viewed Articles

User Comments

No response found, be the first to review this article.

Submit feedback about this article

Please sign in to post feedback

Latest Posts