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;

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers  

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers   Patni,

---

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

---

Pls Explain about the different between 6.5 & Xi R2

2 Answers   IBM,

---

Any body help me...what are challenges did u face in Business object project?

1 Answers  

---

can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,

---

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,

---

Can we link the oracle and excel universess?

1 Answers  

---

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,

---

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,

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  

---