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;

how to make a report avilable to other users?

2 Answers  

---

How would you format some text using css to be verdana and bold?

0 Answers  

---

What is the prm file ? can anybody explain me ?

2 Answers  

---

what is the different between link and join ?

2 Answers  

---

What is the functional & architectural differences between business objects and web intelligence reports?

0 Answers  

---

Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  

---

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---

What is the use of linling the universes?Thanks in advance

2 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

what is performance tunning in BO in report level& designer level?

1 Answers   IBM,

---

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  

---

What are different types of saving options in web intelligence?

7 Answers  

---