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
MDX queries to get Parent/Child and Gen/Lev format (sort of) - I recently stumbled across some interesting MDX functionality. Unfortunately I have to put the disclaimer right off the bat that sadly this feature may no...
3 days ago