what is tuning of business reports ?
Answers were Sorted based on User's Feedback
Answer / prakash
Are you asking Business Objects reports tuning, if "Yes"
then, the answer is
- By reducing the number of variables
- By reducing the number of Data providers
- By pulling the exact amount of the data from the database
- By reducing the complex variables
- Do not check the "Refresh on open " report.
these are the some of the possible ways of tuning the
reports.
Is This Answer Correct ? | 35 Yes | 1 No |
Answer / v.sivakumar
To add some with the before answers
Avoid Using objects from dreived tables.
Reduce the joins in the query.
Create index in the database level.
Apply the filter Properly as per the logic
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / naveen.g
using prameters in universe level.
creating view in database level.
creating index in database leavel.
increasing araay fetch size.
increasing arry bind size.
using correct operator,expression in report level.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gowthami
Removing unwanted objects from BO query panel
Removing unwanted variables
Prefer to prompts instead of drill filters or input control or block filters
Is This Answer Correct ? | 0 Yes | 0 No |
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
What are the join problems comes appart from loop,chasm & fan Traps
Difference between Object varification and validation
which is the best way to resolve loop context r alias why?
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....
What is ment by For each For all function. In which case we use the option in BO?
CAN A REPOSITORY CONTAINS REPORTS?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
Is there any other repository domains rather than universe, security, document?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.