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

how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers   Accenture, TCS,

---

WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,

---

Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks

1 Answers  

---

what is universe

4 Answers   TCS,

---

rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?

1 Answers  

---

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

8. How much supervision have you typically received in your previous job?

0 Answers   CST,

---

Explain the difference between compatible and incompatible objects?

0 Answers  

---

How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  

---

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  

---

Give some information on report bursting?

0 Answers  

---

What is object stores?

0 Answers  

---