How to increase Analysis Studio performance

Users who are used to Powerplay Web find Analysis studio slower during many operations.

Analysis Studio and PowerPlay Web are two different products based on different architectures, different product features so performance cannot be compared between the two. However there are a few techniques that can be used to speed up the display of OLAP reports in Analysis studio.
There are three things that increase with Analysis Studio Performance:


Enable Crosstab caching
If you enable crosstab caching on your cube in Transformer prior to it being built you will also see an improvement in performance. This option speeds up cube access in PowerPlay by storing summaries for the default view PowerPlay crosstab in the cube (first and second dimension and first measure define in the model) . It will slightly increase the cube size and so does not speed up cube creation times in Transformer. But it speeds up the default report display time in PowerPlay.

Increase Sort Memory/Read Cache
Just as in Series 7 PowerPlayWeb, viewing the contents of the cube will be quicker if you adjust the read and sort memory. In Cognos 8 Sort Memory is found in Cognos Configuration under Environment. Read Cache is found in c8/configuration/ppds_cfg.xml file

Reduce Rows per Page
This is where gain most. In Analysis Studio there are many more underlying components of each cell which causes rendering time to cost more then PowerPlayWeb. To cut down on the time taken to return the report in AS reduce the rows per page from the default of 200 to something more manageable such as 25 - 50. Rows per page property is found in the c8/configuration/ansproperties.xml file. Remember to rename the file from ansproperties.xml.sample to ansproperties.xml once it is modified.

 

www.cogknowhow.com