ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
if we run a report it is taking so much time to display the 
report,what to do to increase th performance of the report
 Question Submitted By :: Mail2nare
I also faced this Question!!     Rank Answer Posted By  
 
  Re: if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Answer
# 1
if we run a report it is taking so much time to display the 
result to be fallowed as :

     1) use aggrigate tables(contains pre caliculated data) 
     2)pre defined conditions,LOV's
     3)in a real time senario query contains a large if 
statements.some times we need to wait max of 30 min to run 
perticular statement...not all
 
Is This Answer Correct ?    1 Yes 0 No
Vams_gk
 
  Re: if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Answer
# 2
If the question is not pertaining to query optimization, I 
would prefer not to use much of formatting on the page. One 
can keep the report without any page formatting as this 
would take a very long time. Try not to use the slice & 
dice panel as this would also take considerably long time...
 
Is This Answer Correct ?    0 Yes 0 No
Ilaw
 
 
 
  Re: if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Answer
# 3
Remove unnecessary objects and variables if any.make sure 
you remove alerters if any unless it is the 
requirement.Take the report query and run in Database.See 
how much time its taking.From report query check whether 
in 'where' clause columns have indexes.If not discuss with 
oracle admin and add indexes.
 
Is This Answer Correct ?    3 Yes 0 No
Srikanth
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
What is the use of linling the universes?Thanks in advance  2
WHAT IS CARTESIAN PRODUCT?  4
What is shortcut join?could give any one example?  2
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?  4
what is difference between folders and category ? Tech-Mahindra4
When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?  2
what are the documentations u r created? Wipro1
What is the difference between Thin client & thick client?  2
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?  3
how do u resolve contexts ? Wipro4
What is the Drill filter and it's usage?  2
What are the Errors in BO Pls Explain with Examples iFlex2
where are objects are stored ? Tech-Mahindra4
what is prompt? Cascading prompt? Syntax TCS3
what is data cubes??  1
Can we have multiple domains?  3
what are the differences between web intelligence reports and crystal reports ? AG-Technologies2
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)? IBM4
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,) TCS2
Example of how the fantraps and chasm traps works? IBM1
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com