How would you deal with performance problems in SSAS?
We can tune performance in SSAS by the following methods-
- Use Partitions
- Query engine cache should be efficiently used.
- Write efficient multidimensional expressions.
- To reduce the number of records defines effective aggregations.
BY Best Interview Question ON 10 Nov 2020