Answer Posted / ratnakar neti
To improve the performance of Reports we have to check the
following .
1.check the number of subreports.If more number of
subreports are there it will kill the performance of the
report
2.check the loops. We have to reduce the no.of loops to
increase the performace of report
3.generate the Lov's
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
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 and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain about a time when you discovered a more efficient way to do a work task?
Explain when we use aggregate awareness function in designer?
What Is The Difference Between Oltp And Olap?
Explain difference between zabo and webi?
What is the dense rank?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
what is the difference b/w the refresh and buffered data?
Explain what is the difference between business requirement document and use case document.
(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.
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?