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

What are Alerter, Filters, Breaks and Conditions?

2 Answers  

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

2 Answers   Nucleus Software,

---

How will you know the version of Bo using designer?

4 Answers   Tavant Technologies,

---

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

0 Answers   TCS,

---

what is fantrap ?

5 Answers   Tech Mahindra,

---

how do u resolve contexts ?

6 Answers   Wipro,

---

We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  

---

Explain about Short cut join?

2 Answers   Wipro,

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,

---