what is performance tunning in BO in report level& designer
level?
Answer Posted / guest
Analyze Report SQL for unnecessary Joins
1. First get the list of reports which are performing low
and get their SQL.
2. Analyze the report SQL for joins. There could be
unnecessary join which is causing query to perform low.
make a change in your universe accordingly to generate
query with optimized joins.
Analyze report Query for Indexes.
1. Get the report SQL , check the where clause
2. Check if indexes are user properly in SQL and also they
exist in database
Use Aggregates for measures
1. Use Aggregate aware for your measure objects to use
summary tables form Database
Use Partitions for high volume fact tables
1. Partitioning the fact table can boost your query
performance.
Array Fetch Size
1. Play with Universe options for setting up optimal value
of Array fetch Size parameter.
Universe Analysis for Shortcut joins
1. Analyze your reports and universe for possible use of
shortcut joins as they play little but important role in
performance.
Index Awareness
1. Try using Index Awareness from Universe side to generate
optimized query.
Universe Cleaning.
1. Make sure LOV is disabled measure objects.
2. Make sure LOV is disable for un-necessary dimension
objects and detail objects.
JOIN_BY_SQL
1. Try evaluating JOIN_BY_SQL universe parameter
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
what is document design in boxi,have u participate in that
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 ?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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?
What is the difference between business requirement document and use case document.
What is Indexing? how did u implement indexing?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What would you consider as your biggest achievement and why?
Can Bo generates the Report from the cubical data Explain?
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:
Explain how to schedule the report in b.o?
Explain in detail about type 2(scd),
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?
How to open a universe with out using the Designer ??
Explain what sort of existing documents should business analysts refer to when starting on a new project?