Answer / shamanth

Aggregation will be defined at lowest level only, because
we can move/drill anytime from lowest-highest but viceversa
(highest-lowest) is not possible.

Defining aggregation at the lowest level is best practice
to improve performance.

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

Tell me about a complicated object you have created?

1 Answers  

---

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  

---

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

---

How can we improve performance?

2 Answers  

---

How to get top 5 rows of a selected column?

3 Answers   Patni,

---

How to execute the plsql procedure from the report by clicking with mouse?

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,

---

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---

What are universe parameters?

6 Answers  

---

CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

2 Answers  

---