The other day Tim Tow on his blog talked about opening outlines and commented about how slow ASO outlines created in EIS or Essbase Studio were to open.
I've seen that and have a number of large outlines that don't seem to compact. I have one very similar to the zzzz application Tim talks about. sitting at about 122 meg. I tried to compact it and brought it down to 120 Meg. Still big and still slow to open. This is where OTN came to my rescue. There is a extension to Esscmd (yes Esscmd not MaxL) that calls the outline API. This is used by Oracle internal Quality Engeneering to test the API. On the page they have a PDF that explains how to compact an ASO outline. I tried it and my outline went down to 8K and opened in a few seconds. Simply amazing results.
I've sent this post to Tim and hopefully he will test his instance and will report on the results.
I guess I should tell you where to get this godsend. You can download it from http://www.oracle.com/technetwork/middleware/bi-foundation/esscmdq-sampleapps-093105.html?ssSourceSiteId=otnjp
EPM 126.96.36.199.500 revisited - As I previously posted (http://wp.me/p2jaSq-2k), the Essbase 188.8.131.52.500 patches include many new features, but that was not all. Oracle had another patc...
1 week ago