2
kudos
spam Kudos Remove

Improving cell security performance in SSAS - Some Random Thoughts

published 736 days, 5 minutes ago posted by jacobsebastianjacobsebastian 745 days, 22 hours, 54 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Friday, May 07, 2010 11:01:44 AM GMT

Now this one was in the coming for quite some time. All of us who have tried to implement cell security would have had some or the other woes to relate with performance. At least for me, the MDX query which I had beautifully tuned to come out in 2 sec suddenly became an embarrassment in the form of a hideously slow 2 min query the moment I switched over to a security based role. And this blog is a direct result of my quest to understand how SSAS works beneath my mean machine (yeah, my laptop is damn cool!).

category: Analysis | clicked: 0 | | source: beyondrelational.com | show counter code

No comments yet, be the first one to post comment.

To post your comment please login or signup