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 is a bo repository?

0 Answers  

---

it is possible to link two universes of separate functional domain ?

1 Answers   IBM,

---

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---

where are objects are stored ?

6 Answers   Tech Mahindra,

---

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

---

Difference between drill by and drill across with example?

4 Answers   TCS, WNS,

---

what is dashboards? what is metrics?

7 Answers   TCS,

---

How to resolve the partial result error in the report

4 Answers   Keane India Ltd,

---

How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  

---

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

0 Answers  

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  

---

who r the users in B.O.XIR2?

2 Answers   PCS,

---