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...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / glhanumantharao

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 dtm?

0 Answers  

9. What was the most complex type of report you dealt with?

0 Answers  

What is zero-foot print?

0 Answers  

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,

How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,

wt is scope relationship?

2 Answers  

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers  

what is the difference b/w mdx and sql?

4 Answers   Cap Gemini, IBM,

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  

How to create a cube in Transformer? What is the process? Please mention process thank u

0 Answers   Genpact,

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

For more Cognos Interview Questions Click Here
Categories