Following are the reasons for
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
No comments:
Post a Comment