MSBI -- SSAS -- Part-1

MSBI -- SSAS-CUBE -- Part-1

What is SSAS:

                   SSAS Stands for SQL Server Analysis Services. SSAS is a one of the OLAP(Online Analytical Solution) and Data Mining Tool. Which is used to Create the Cube.

What is CUBE:

Cube is a Multi Dimensional Object, which stores measures data across different dimensions in the form of cells.

Advantage/Usage of Cube:

1.     More Flexible for Adhoc Reports

2.     Using Cube, we can reduce the query processing time for end user applications

3.     Cube contains the Pre-Calculated aggregated data in cells.