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

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

What is self join

2 Answers   Blue Star, IBM,

---

How to change font color of values in hyperlinked columns?

4 Answers  

---

---

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

---

Explain what is the difference between business requirement document and use case document.

0 Answers  

---

can anybody tell me about issues faced while creating reports

3 Answers   Accenture,

---

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers  

---

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

---

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

Analysis in business objects?

4 Answers  

---