Thursday, 17 May 2012

What is the Business Intelligence Semantic Model Denali

Business Intelligence Semantic Model (BISM) is the new name for Analysis Services in Denali similar to to Unified Dimension Modelling (UDM) for Analysis Services 2005. BISM is the new Analysis Server 2012 + PowerPivot. BSIM strives to achieve one model for:

  1. Reporting
  2. Analysis
  3. Scorecards
  4. Dashboards
In BISM there are two types of Analysis Services offered. Multidimensional (Cubes), and Tabular (Tables and Relationships). The Tabular model is the server version of Power Pivot. Power Pivot for SharePoint or Excel runs on the VertiPaq Storage Engine.

Vertipaq requires a dedicated SQL Server Analysis Server instance which only responds to the PowerPivot system it does not store the data in but instead computes aggregations on the fly, thus data retrieval and calculations happen at a much faster rate, as disk I/O processing is omitted.  

Advantages of the Tabular Model:

  1. Faster to Develop
  2. Prototyping
  3. Easier to Modify
  4. Use Less Resources
  5. DAX is easier to learn than MDX

The multidimensional model (cubes, dimensions & hierarchies)is what we have today with MDX and MOLAP/ROLAP storage. Both the BISM models cannot co-exist on the same Denali instance.

No comments:

Post a Comment