Any of the major BI platforms will do what you want
My honest opinion is to look at your company’s vendors and pick one that has served you well in the past.
I have used Business Objects, Cognos, MS and Meta-Strategy in the past and they all have lots of unused capability…
The databases are completely different and I mean completely different
Hana is an in-memory, columnar database that can mimic a row store in some cases.
SQL Server is anything from a classic relational DB to a distributed parallel warehouse, PDW.
If you are implementing…