Answer / vinay

derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...

Answer / srini

Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;

What is the difference between condition & filter?

0 Answers  

---

What would you consider as your biggest achievement and why?

0 Answers  

---

what is the difference between bo and cognos?

1 Answers  

---

use scheduler to refresh report.....explain please.....

2 Answers  

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

0 Answers   ASD Lab, Wipro,

---

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,

---

What are the steps to taken care to improve the Report performance?

3 Answers  

---

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

0 Answers  

---