Beat your users' performance expectations
Many system performance factorsincluding those for OLAP Servicesinvolve tradeoffs. If you tweak an operation to make it perform faster, you might pay for the speed with performance degradation elsewhere. With OLAP Services, performance tradeoffs occur between cube build time and query time. As I discuss various actions that can influence performance, such as setting up storage modes, setting the aggregation level, querying, partitioning, and using PivotTable Services, I'll point out how these actions affect cube build time and query time.
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: