cognos performance threshold

Question

my cognos reporting team have an issue, few reports take 7 mins to fetch report of 3k records, which references 10+ tables, and sufficient indexes in place. At the earlier stage of the project my ex-collegues have given a wrong probmise to client that such reports can be rendered within one minute which doesn't seem to be realistic. I need to negotiate client with some facts. I need some direction. By the way, possible tuning efforts were already done. Only at this stage we were given 3k of test data and realizing the problem. Clients are reasonable, just that I need to explain them with some standards and fact. Any directions? Thanks in advance

Answer 1

I had similar issues while implementing Cognos BI with Oracle 11g database.I was joining more than 10 tables some with more than million records. I managed to optimize it to run within 1 min by

• Using LEFT Joins in SQL
• Creating Functions or Materialized views
• Creating indexes within the tables
• Pasting SQL Directly in Report Studio

Hope this Helps.