Sunday, December 3, 2017

SQL Server - Why SSAS Cube is needed?

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