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

Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers  

---

What is the difference between the public object&schema object?

0 Answers  

---

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 Answers  

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

how will you move the universe/report from development to production?

3 Answers   TCS,

---

---

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

what is master-detail report

3 Answers   Patni, TCS,

---

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,

---

What is the architecture of ur project? can u explain it? PLz

1 Answers   Patni,

---

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

0 Answers   Accenture, TCS,

---

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

How were the reports scheduled and how to resolve unexecuted documents?

0 Answers  

---