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

am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

---

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers  

---

bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

7 Answers   PCS, TCS,

---

what is document design in boxi,have u participate in that

0 Answers   Accenture, TCS,

---

---

can anybody tell me how many classes where there and objects in each class

3 Answers  

---

what is canned universe and canned reports in bo?

1 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  

---

What is package in BO

0 Answers   Infosys, Saksoft,

---

how to create dashboard reports

4 Answers   TCS,

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

---

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,

---