SQL Server 2012 introduced a new concept called Business Intelligence Semantic Model (BISM). In this 3 part series, we will take a look at this new concept, pros and cons of traditional multidimensional and new tabular models, considerations, recommendations, best practices, and few tips and tricks.
In this first part, we will take a look at what BISM is all about and get an initial understanding of this whole new concept.
Prior to SQL Server 2012, we had the concept of Unified Dimensional Model (UDM) for creating the multidimensional structures (OLAP Cubes) and data mining models. Microsoft introduced a new in-memory technology, with SQL Server 2008 R2, called “xVelocity” (Formerly “VertiPaq”). This technology was initially implemented with PowerPivot. With SQL Server 2012, Microsoft introduced BISM, which brings the capabilities of traditional UDM and the new xVelocity under one umbrella. BISM is implemented in the following formats:
Traditional Multidimensional & Data Mining Models (Popularly known as SSAS Cubes)
Analysis Services Tabular Models
Power Pivot for Excel/SharePoint
To continue reading the first part of this series, catch the full article here: Choosing between Analysis Services Multidimensional and Tabular Models Part 1.
In the next part of this series, we will take a look at the similarities and differences between the above implementations of BISM.