11/21/09

Optimizing ASO Outline Page

Aggregate storage database outline is pageable, therefore, ASO can put huge members in memory that will significantly increase the running performance.Depending on how you want to balance memory usage and data retrieval time, you can customize outline paging for aggregate storage outlines by using one or more of the following settings in the essbase.cfg file:
● PRELOADMEMBERNAMESPACE to turn off preloading of the member namespace.
● PRELOADALIASNAMESPACE to turn off preloading of the alias namespace.
● Compact outline from time to time, that is because when a member is deleted, it is not really deleted inside the file, it is actually marked as 'deleted', if you don't compact the outline, it will become huger and huger.