Applying security to a cube comes at a cost to query performance. However, since we don't usually have a choice about whether to apply security or not, we then need to understand which security features have the least impact on performance when choosing which ones to use. In this final section, we'll give some details on the relative impact on query performance of each type of security.
Cell security has by far the biggest negative impact on query performance, and for this reason alone, you should use it when there is no other option. Remember also that there are two different types of cell security, Read and Read Contingent; Read Contingent cell security has more impact on query performance than Read. The reason why cell security is so bad is because it prevents Analysis Services from using many important query optimization techniques. For example, in many cases it appears to completely prevent the use of the Formula Engine cache, so the results...