What are some effective ways today to implement a dynamic OLAP (Online Analytical Processing) system that supports multiple users to connect their own databases and provide real-time data analysis capabilities?<p>requirements:<p>+ There are multiple users, each user has their own data/databases.<p>+ Users may dynamic query their own data (like aggregation, filter) at same time.<p>I am looking for suggestions on technologies, tools, and best practices for building a scalable and efficient solution that can handle dynamic and large scale data. Any insights would be greatly appreciated.