Why I created a blog

Its been four years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Friday, June 11, 2010

ASO Outline Compaction

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. 
http://timtows-hyperion-blog.blogspot.com/2010/06/essbase-outline-performance-testing.html

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

 
While not a supported application ,it does have versions for all of the platforms and for versions from 6 to 11.

8 comments:

jajc said...

Glenn, I tried to get the utility from the link you posted but got error. Your link works, but then the links within that page don't work for me.

GlennS said...

I too just tied the links and they are broken. I'm not sure who to contact to get them fixed. Maybe they read my blog and decided that it was an embarassment to say this works

GlennS said...

While the link was broken before , it seems to be working corectly now

Anonymous said...

The link works but I oped a dozed zip files and they are all missing a file so you cn't execute.

On AIX I get,
Could not load program ESSCMDQ:
Dependent module /essapp/hyperion/products/Essbase/EssbaseServer/bin/libessapinuS.a could not be loaded.
The module has an invalid magic number.

GlennS said...

I used it on Windows and found I had to create a bat file that brought in locale information. I also needed to run it from a directory Hyperion/common/EssbaseRTC/9.5.0.0
which I believe stands for Run time client verion 9.5 (9.5 = 11X)

Tey Brady said...

Glenn,
Thanks for sharing this! I talked to you a little about this at the Dallas Oracle User Group. I finally had a chance to try it and it sped up both the time it takes to open/edit outlines and build the outlines by around 90%. Waiting 10 - 15 seconds for an outline to open is not as painful as waiting between two and three minutes. Dimensions builds taking one minute instead of 10 is also nice.

Thanks again!

jithendra said...

great info Glenn. you can download the utility link from the below link
http://www.oracle.com/technetwork/middleware/bi-foundation/esscmdq-sampleapps-093105.html

trei said...

just tried it with an outline of 741 MB size. Unfortunately afterwards the size was 766 MB...
In an other try I reduced the outline size from 19 MB to 16 MB...