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 Posted / srikanth
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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is Indexing? how did u implement indexing?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Difference between zabo and webi?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What would you consider as your biggest achievement and why?
Explain when we use aggregate awareness function in designer?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
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?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain which versions are used in the bo dashboard work?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is xcelsius architecture?