All we need is an easy explanation of the problem, so here it is.
What has faster performance speed: Columnstore Indexes or SSAS Cubes? Are Columnstore indexes proven to be faster than SSAS cubes (SQL Analysis Services)? Have their been any performance studies conducted by Microsoft?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
There is no single right answer to your question.
Its worth noting they are not mutially exclusive technologies. You can have an OLAP cube reading from table using column store indexes.
The performance of each in various scenarios will differ depending upon the size, number, complexity of tables used and granularity/sparcity of data within them.
It will also depend upon the variability of queries used. Are they frequently aggregating? Or constantly seeking row level data?
The only way to know for sure in your case is to test your queries and scenarios with representative data.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂