SSAS – Choosing between Analysis Services Multidimensional and Tabular Models – Part 1

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.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on September 2, 2013, in Business Intelligence, Power Pivot, SQL Server, SQL Server 2012, SSAS and tagged , , , , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: