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 we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

1 Answers   HCL,

---

I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

3 Answers   IBM,

---

In banking domain how many Fact tables,Dimension table are present?

0 Answers   TCS, UST,

---

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 meant by report busting

2 Answers   TCS,

---

---

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,

---

HOW TO INSTALL BOXI

1 Answers  

---

What is global filters and local filters

3 Answers   IBM,

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---

When to use local filter and when to use global filter?

0 Answers  

---

how we send repotrts/documents to end user

2 Answers   HP,

---

please anyone explain me the derived table with the problem tables.

1 Answers   CTC,

---