As we all agree, the relational data model is relatively easier to understand and used by a larger group of developers than multidimensional models, hence it makes sense to embrace the relational/tabular data modeling for broader adoption and to ensure utilization of customers’ existing investments and skill available with them. The Business Intelligence Semantic Model (BISM) is a single unified BI platform which has both multidimensional as well as tabular data modeling capabilities to offer best of both worlds and choice for the developer. BI Semantic Modeling (BISM) Primerīefore diving into the detailed differences between multidimensional and tabular modeling, let’s begin with a brief primer on each of the BISM modeling experiences provided by SQL Server 2012 Analysis Services. Some of the tangibles that also play a role are the BI Semantic Model (BISM) and the “different flavors of analysis” that were introduced originally with SQL Server 2012.
Obviously there could be more considerations you should take when making this decision for your organization, but those could differ depending on your organization, team, and other factors.
#ANALYSIS SERVICES TABULAR VS MULTIDIMENSIONAL SERIES#
In this series of posts we’re going to be covering 5 main considerations. Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services (Tabular or Multidimensional) you should have used or should use? Recently, I was doing a presentation on SSAS Multidimensional best practices and following the presentation one of the attendees asked a very good question, “When it comes to SSAS Tabular versus SSAS Multidimensional how do I know which one to choose?” We discussed some of the various aspects of each one, but during the conversation I realized I needed to put a presentation and ultimately a blog post together on this topic.
0 kommentar(er)
