Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps

1 Answers  


Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 Answers  


Can you define framework manager?

0 Answers  


-------------How to do Bursting a Report?

1 Answers   Cap Gemini,


how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  


What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  


Hi,please suggest me how to creat username while creating a report.

1 Answers   IBM,


what are determinants?

4 Answers   Dominion,


Mention the difference between ‘macros’ and ‘prompt’?

0 Answers  


Can u please describe the different types of traps with eg. Thanks

2 Answers  


What is difference between content store and content manager?

0 Answers  


Is cognos models are version compatible?

2 Answers  


Categories