Trying to decide between BISM Multidimensional and BISM Tabular?

portfolio1 portfolio2 portfolio3 portfolio4

Business Intelligence Consulting

OLAP Business Solutions offers fully customized consulting services for your business intellgience needs.

Customer Testimonials

Look at what our customers say about us...

Mentoring

OLAP Business Solutions prides iteself on knowledge transfer and mentoring during the consulting process.

Customer Testimonials

Look at what our customers say about us...

small portfolio1 small portfolio2 small portfolio3 small portfolio4
Business Intelligence Consulting
get in touch

Multidimensional vs Tabular

Microsoft now offers two types on analytic database. There is the "traditional" BISM OLAP and the new BISM Tabular version. The 2012 version of BISM OLAP is very similar to SQL Server 2008 R2 Analysis Services. But the new "tabular" version is quite different and offers some advantages and disadvantages to the current "cubes". Having a "choice" means that companies will now be able to apply the best technology fit for their applications. But it also means that before you begin bulding your BI application, you will need to decide which platform you will be using. In general, the new BISM Tabular offers advantages for the following types of applications:

  • Users like to query large amounts of detail data
  • The cube has a lot of “distinct counts”.  (These query much faster than in BISM – OLAP)
  • The cube has a lot of “degenerate fact table” dimensions.  (this is automatic in BISM – TABULAR)
  • Query performance is of great importance
  • Customer Segmentation Analysis
  • Events in Progress Analysis

 

slide up button