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


1 comment:

  1. This website can live streaming , you can join at my site :
    agen judi online terpercaya
    Prediksi Bola

    Thank you
    agenpialaeropa.club
    gamesonline.ga
    beritasemasaterikini.net

    ReplyDelete