Do we have specific scenario examples of when ROLAP is fit over DirectQuery/vice versa. Direct Query needs data to be in single SQL Sever. Let us assume that we have the dimension modeled data in Single SQL Server - then DQ or ROLAP which is best fit.
I would like to leave the feature of Writeback aside.
A comparision of ROLAP against Tabular/Direct Query would be helpful in the areas of Modeling, Processing Architecture, Cacheing etc.
Yes that Tabular/DQ and ROLAP are similar in lines by their overall offering and have thier own capabilities. But the idea is that to bring the differences by quoting them to business scenarios against the assumption of having Dim Model based Physical Schema
in a Single SQL DB. Would like to see if we havethe clear list side-by-side comparing ROLAP/DQ in Processing Architecuture/PRocessing Need, Real-time Support/cacheing etc, data source support etc.
Why should one go to Tabular/DQ if ROLAP provides the same functionality (from developer perspective).
Does ROLAP need Dimensional modeled source to provide better performance!
Should we use Tabular only if our source is in more relational format!
BTW. Thanks for adding MSDN link on DQ. Below are other links that can will help this