how to improve the performance of the report

Answer Posted / babu

Report performane will improve by the given following
things.

1. Should disable LOv's for unnessary measure objects.
2. Create conditions at Universe level and try to reduce
the variable's and bulit complex logic's in universe and
database level.
4. use query level filters.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is thumbnail?

580


When to use local filter and when to use global filter?

603


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1779


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1584






In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829


What sort of existing documents should business analysts refer to when starting on a new project?

624


Explain the data types present in bo and what happens if we implement view in the designer and report?

564


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

604


Explain what would you consider as your biggest achievement and why?

578


Explain when we use aggregate awareness function in designer?

590


Explain is data mart?

596


how to create reports on screech?

2079


What is aggregate table and aggregate fact table ... Any examples of both?

614


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2402