How does declaring the hierarchy and level in SSAS help to improve MDX Query performance?

0
votes

I use SSAS in SQL Server 2008 R2 and I'm reading the book Professional Microsoft SQL Server Analysis Services 2008 with MDX Wrox Programmer to Programmer.

In chapter 5 on page 132 it says that declaring "hierarchies and level" is better for query performance. Can someone explain why this is?

1
ssasmdxolapcubeolap-cube
My friend Voters.A positive or negative does not matter to me. But please, when you have a negative comment, please write to me so I can not modify my question. No vote without stating a reason, show your ignorance of the subject. – Ardalan Shahgholi

1 Answers

3
votes

If SSAS server knows the relationships between levels, it can do optimizations to reduce the sets it is dealing.

For example, if you have a hierarchy with sales manager and clients, by knowing the sales manager, cube can reduce the number of clients checked. This can be done on the dimension itself without going to the facts.