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

What is the difference between Thin client & thick client?

5 Answers  

---

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

4 Answers   iGate,

---

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

---

What is Cartesian product?

14 Answers  

---

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,

---

How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  

---

What is broad cast agent?

5 Answers  

---

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

---

How to create Universe using Flat file in BO6.0

1 Answers  

---

Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  

---

Can we link the Universes from two different sourcess?Explain?

2 Answers   IBM, Oracle,

---

how we send repotrts/documents to end user

2 Answers   HP,

---