Answer / amritha

I have no idea about BO6.5 however I feel that creating
Derived table must be similar in both XIR2 and BO6.5.

-right click any where in Designer.
-select Derived table from Popup menu.
-A window will open up. Give the name of the derived table,
You can specify the SQL stmt here as you do for example in
oracle(if you are using oracle DB).

Example:
select BONUS.ENAME Ename,DEPT.DEPTNO,EMP.EMPNO from
Bonus,dept,emp where EMP.DEPTNO=DEPT.DEPTNO

You can specify the join in SQL stmt if necessary.

However joining the Derived table indeed is similar as
joining a normal table.

Thanks,
Amritha

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,

---

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,

---

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,

---

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers   Keane India Ltd,

---

what is document design in boxi,have u participate in that

0 Answers   Accenture, TCS,

---

what are they different types of report in BO?

6 Answers  

---

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

---

Explain the difference between union and group?

0 Answers  

---

What is the user Object ? What is the need of it?

2 Answers   iGate, Infotech,

---

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  

---

IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,

---