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
how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u 
take ?
 Question Submitted By :: Narasimha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
Answer
# 1
To increase the performance in designer
1. Use as much conditions as possible
2. Use array fetch parameter
3. Limit the number of rows in Universe parameters as per 
ur need
4. Resolve loops completely etc.,
To increase performance in reports:
1. Avoid usage of more variables
2. Use indexes on columns 

Still more points are there, i didn't remember. Any body 
can continue this post
 
Is This Answer Correct ?    0 Yes 0 No
Anil Kumar Ganga
 
  Re: how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
Answer
# 2
To increase the performance in universe:

-as possile as use less number of joins
- avoid use of user objects
- use aggregate awareness

To increase the performance in reports:
- avoid use of user objects
 
Is This Answer Correct ?    3 Yes 0 No
Poonam Tekchandani
 
 
 
  Re: how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
Answer
# 3
1. Increase array fetch size.
2. Use Bit map indexing on Fact columns.
3. Remove unwanted objects and classes from your universe.
4. Remove unwanted variables, filters and charts from report
5. Always ensure your fact table execute before your 
dimensional table in the FROM clause (Query optimization)
  ex.  Select F1.A
        D1.B
       FROM
        Fact F1,
        Dim D1
6. Use of Derived Tables so that complex calculation can be 
performed at universe level.
7. Aggregate table
8. Remove unwanted alias and context.
9. Always ensure in join condition you have fact table 
appearing at LHS. (F1.A=D1.B)
10. For prompts related columns, have indexing done at DB 
level
11. Also at universe level you can change row count for 
table rows for SQL execution as per requirements.
 
Is This Answer Correct ?    1 Yes 0 No
Ashish
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM? CitiGroup3
can BO generate reports with out CUBICAL data to repository?  3
What is pragma?  1
Instead of cms which server you have to use? CTS2
what are they different types of report in BO?  2
HOw do u migrate from old version to the new version? AOL1
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?  1
What is the server based ranking? and its usage?  2
How do u Receive requiremnts from the client?  2
how to make a report avilable to other users?  1
What are the diffrences between Business Objects 5.1 & 6.5 ? Siemens1
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
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ? BNP-Paribas1
could you please give me the diagram of BO 6.5 Architecture or explain about the tires? PCS4
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2? IBM4
what are the documentations u r created? Wipro1
am a fresher hw to get real time experience?  1
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.  1
what is a filter?  3
Tell me the difference between cmc and cms? Wipro3
 
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