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 import BIAR file in bo?

1 Answers   Emirates, Zensar,

---

what is merged imension in 6.5 and webi

1 Answers  

---

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,

---

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,

---

what is the difference between breaks and sections?

3 Answers   IBM,

---

---

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,

---

What is top business?

0 Answers  

---

How to create predefined filters in B.O.

2 Answers   TCS,

---

What is the difference b/w breaks and sections

2 Answers   IBM,

---

Explain in detail about type 1?

0 Answers  

---

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,

---

Explain how to schedule the report in b.o?

0 Answers  

---