- Try converting the Big1.Big1 outline to ASO using the wizard, then compare performance; and
- Try compacting the outlines using the free Oracle ESSCMDQ utility that Oracle QA uses for testing.
|Updated Analysis (click image to view in a larger window)|
There was, however, a big impact on the zzz outline that was generated by Essbase Studio. The filesize was reduced by 91% and the time to fell by an average of 75% (or nearly 45 seconds).
The customer who provided the zzz outline compacted their outline and have reported it opens much faster in their environment. As a result, it looks like compacting may have an impact on outline open operation performance with more significant results on Essbase Studio generated outlines.
Thanks to my friends Glenn Schwartzberg and Edward Roske for pointing out the availability of ESSCMDQ which is available at http://www.oracle.com/technology/products/bi/esscmdq_sampleapps.html. I would heavily recommend you backup your outlines before running this utility as it is not available for every minor version of Essbase and I had it crash on my laptop a couple of times. By the way, on my 18.104.22.168 laptop, I had to use ESSCMDQ 9.3.1 as ESSCMDQ 22.214.171.124 threw an exception.
Finally, I am thinking of doing a poll on the blog about results you see when compacting your outlines. Would you like to participate in that poll? Also, would you be interested in the Java code I used to run the testing? If so, I will do another blog post to explain how it works and will make it available from our website.