Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE
LONG TIME IN CONGNOS?

Answers were Sorted based on User's Feedback



WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?..

Answer / joydeep

go through the generated sql and try to compare it with the
regular sql code by running the sql in the navigator. that
will give you an estimate of the time difference.

secondly try to check the joins. avoid outer joins as far
as possible.

thirdly try to add prompts and filters if possible to
reduce the number of records to be pulled into the query.

Is This Answer Correct ?    5 Yes 1 No

WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?..

Answer / ajay

deselect the option auto-aggregate&sumarry option if it
selected it takes much time to get the data

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Cognos Interview Questions

What is catalog and types of catalogs in cagonos and which is better?

0 Answers  


What is a Transformer?

0 Answers  


how u publish the packages in framework manager

3 Answers   TCS,


What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?

2 Answers   HCL, TCS,


What are the advantages of using cognos sql?

0 Answers  






Tell me about Dnamic and Static Dashboards?

0 Answers  


What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,


I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

2 Answers   Cap Gemini,


What is the difference between a cascading report and drill through the report?

0 Answers  


What do you understand by the cognos?

0 Answers  


If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

2 Answers   IBM, Polaris,


-------------How you design DWH?

0 Answers   Bank Of America,






Categories