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;

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

when we go for snow flake schema rather than star schema ?

5 Answers   TCS,

---

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,

---

What is a loop? How can we overcome?

5 Answers  

---

WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,

---

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers  

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,

---

Can anybody explain what mean by Database Delegated Measures?

2 Answers   TCS,

---

What is casual dimension?

4 Answers  

---

how to find the size of the report

1 Answers  

---

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

---