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;

Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers  

---

i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?

2 Answers  

---

what are the documentations u r created?

2 Answers   Wipro,

---

How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

1 Answers   HCL,

---

why we are using derived tables ?how it will help?

2 Answers  

---

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,

---

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 Answers  

---

Can we create universe with no cache??

1 Answers  

---

Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,

---

what is optional prompt in boxi r2

4 Answers   Mind Tree,

---

what is traffic lighting in business objects?

1 Answers  

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---