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
EPM Shared Services Registry cleaner
-
No doubt you aware of the EPM Shared Services registry but if you are a
little unsure on what it is all about then here is the official Oracle
description....
3 hours ago
Posts
8 comments:
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.
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
While the link was broken before , it seems to be working corectly now
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.
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)
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!
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
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...
Post a Comment