News for hackers. Stuff that matters.
Re:MonetDB – Column-store database by greggyb on Monday June 13, 2016 @07:06PM (#11898500)
Yes. Power Pivot is the reason that I said Tabular arguably came to SQL Server 2008R2, which can run Analysis Services in a mode to support a Power Pivot workbook hosted on SharePoint. There was no standalone SSAS Tabular, but the Vertipaq engine and DAX were run on a SQL Server instance.

Power BI Desktop (and hosted data models on the PowerBI.com cloud service) is also powered by the Tabular engine and utilizes DAX as a query and modeling language.

Microsoft is pushing Tabular hard. It's probably the right choice for most organizations, and at worst serves as a great prototyping tool for a Multidimensional model (when we have clients who need Multidimensional for whatever reason, we often still do initial development and pilots on Tabular).

Re:MonetDB – Column-store database by blahi on Tuesday June 14, 2016 @03:01AM (#11900282)
Thanks for the answers. Really appreciated! I am analyst and I deal with databases, but in a very specific way. The way I tried to explain to myself the difference is that OLAP is used if you have a lot of fine-grained hierarchies accessed by a big number of people. In this scenario it would make sense to make all those aggregations ahead of time because a columnar store would have to calculate them each time somebody slices and that would be waay to expensive, even if you have state of the art caching.
Re:MonetDB – Column-store database by greggyb on Tuesday June 14, 2016 @10:02AM (#11902059)
That is a useful distinction to make, but as in all programming tasks, profiling will get you further than intuition when tuning for performance.