Following are the reasons for
choosing the SSAS Cube
choosing the SSAS Cube
- High Performance
- Multi dimensional
analysis - Built-in advanced time-calculation
- Stores hierarchy data
- No SQL Joins required
- Easily use Excel to view
data from Cube - Automatically manages
slowly changing dimension problem - Build in support for KPI
- Security setting to give end-users access to only those
parts (slices) of the cube relevant to them - It supports partitioning
of data - It supports reporting
services, PPS & Power view to create reports - Can utilize for data
mining models