1.

How would you deal with performance problems in SSAS?

Answer»

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.


Discussion

No Comment Found