Lakshmi

 Profile Answers by Lakshmi 

• Jul 16th, 2008

 

By applying the filtres, to eliminate the un wanted data,by using local limited local processing,by using agregations for facts(numerics).

To improve the performence of the report move all the calculations and filters from report level to frame work manager.

bonniewade1

 Profile Answers by bonniewade1 

• Jan 14th, 2011

 

1) Use static values or list of values in prompts when possible.
2) Perform calculations on the database side.
3) Limit the number of rows to be displayed at one time when possible.
4) Take off the auto summarization of the query when you're only displaying attributes.
5) Use the sql to do an explain plan on the query and tune the query.

Madhusudhan Rao.C

• Jan 21st, 2013

 

set the report hints,
limit the maximum execution time,
limit the maximum table retrieving,

Shiv Tripathy

• Dec 14th, 2015

 

Start by checking if the left outer join which is used for relationships, if can be converted to inner joins..if the L.O.J is that much required then make sure the link which is used to maintain the join is an indexed one..indexed columns when used improve the performance

Secondly check if there is an complex query involved which is using three or more tables..what we need to do here is we have to cross join the to cross join the 3 tables and create a view of the joined table in the database and then import the view and then use it as a query subject.

Thirdly set the execution method in the query properties to be concurrent..because it will force to take SQL parallels in the background and the execution will be faster.

Lastly make sure the functions used in the queries are native functions..native functions belong to the database and they are faster as compared to the COGNOS functions used which are involved with the COGNOS server and have an inbuilt database which reduces the performance.