Essbase BSO Performace guidelines

I am sure we all would have faced optimizing ESSBASE BSO cube a tough task. As you all know there is not technical / rule to optimize BSO cube. I say optimizing Essbase is an art not a science.

However here are some general guideline for optimizing BSO cube.

http://www.intellientblog.co.za/index.php/products/the-dark-art-of-essbase-optimization/#

CLEARDATA ambiguity

This is a very strange observation which I discovered in one of the blogs on CLEARDATA command which challanged my knowledge on BSO CLEARDATA Command. I personally tested it and found that the blogger is correct and so thought of sharing it with you if you all have not visited that blog

CLEARDATA when dealing with purely sparse dimensions…removes blocks

For more details explanation... please refer the blog
http://camerons-blog-for-essbase-hackers.blogspot.com/2011/01/stupid-programming-tricks-6_03.html

Happy posting