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 sdlc in bo?

2 Answers  

---

How do you find what type of trap is there by seeing the report?

4 Answers   TCS,

---

How to Avoid the overlaping the blocks in WEBI.

3 Answers  

---

how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,

---

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

3 Answers   HP,

---

what is performance tunning in BO in report level& designer level?

1 Answers   IBM,

---

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---

Difference between drill by and drill across with example?

4 Answers   TCS, WNS,

---

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

---

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers   Accenture,

---

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---