Day 1: 10:06am – The First Fork – Tabular vs Multidimensional
The first fork in the road seems to be picking an OLAP model – Tabular or Multidimensional.
I’m going with Multidimensional.
As I stated in the outset, it’s not my intention to be thorough in my research and decision-making this week. So, this Microsoft White Paper, and Chapter 1 from my Wrox book have given me enough input to choose the Multidimensional model.
Loosely, the factors in my decision are:
The Multidimensional model has been around a lot longer (5 releases of SQL Server), and is described as the ‘Traditional’ model. Presumably this means it is more stable and mature. I’m also hoping there are more resources out there for me to learn it.
The Tabular model is intriguing to me mostly for its newness. The in-memory xVelocity (aka Vertipaq) engine sound like lots of fun, and I know that I’m ignoring an opportunity to build a quicker, simpler solution using the Tabular model, but I can’t help but feel like it is somehow a shortcut that will bite me later on. It also seems to involve a lot of Excel. With all due respect to Excel and its legion of followers, I didn’t come all the way to PASS in Seattle to play in Excel all day.
Like I said, I’m making snap decisions to get this built, so there we are – Multidimensional it is.
The 6am breakfast of coffee and Pringles has run their course, so my next decision will be where to get some food.