performence and tuning in cognos reports

[Sharma999]

Hi All,

Can any body expalian some thing about performence and tuning in cognos reports.How can we improve performence in our reports.

Thank You

Sharma

 

[sln007]

All prompted columns should be INDEXES....(DB2)
Join colums should be INDEXED.....(DB2)

 

[sharatkb]

Hi,

There is a dedicated chapter for Performance optimization provided in Documentation PDFs: Mastering Impromptu Reports --> Part 2: Reporting Environment --> Chapter 6: Optimize Performance in Impromptu.

Hope this helps....

Regards,

 

[b1ffa]

try to examine the sql to see if you are referencing tables that you do not require data from. The fewer table referenced the faster the reports will run. Also try the flexible processing option.

 

[Bensta]

There is one way to improve cognos impromptu performences.
I heard about many ways, such as Indexing, looking at joins...etc. But sometimes you still find reports to be very slow when run, and that can be a result of many different instances or situations.
One radical solution in my opinion is to built to a copy of the database schema that is updated daily to maintain updated data. Of course it depends on the type of database server you are using. After that you create a generic catalog into which fields can be added by rerunning the SQL script.
That would do the trick.
Just wanted to share this with you guys.
Bensta

 

[DoubleD]

See this thread for more on this subject.

thread401-820734

Pain is stress leaving the body

DoubleD