what is tuning of business reports ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about a time when you discovered a more efficient way to do a work task?

633


Which versions are used in the bo dashboard work?

591


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

541


What is the difference between user and versatile user?

572


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3840






Explain is there any default username & pwd for bo designer & supervisor?

591


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

992


Explain how we drill up week to month?

635


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3125


Explain is there any other repository domains rather than universe, security, document?

576


in sap bi we have wad, then why we go for sap bo

2771


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1685


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1605


what is the difference b/w the refresh and buffered data?

1757


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

547