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 #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,

---

in xir2 how to send reports to end user

2 Answers   TCS,

---

what is Scope of Analysis

8 Answers   TCS,

---

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

---

How can we improve performance?

2 Answers  

---

---

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

2 Answers  

---

what is dashboards? what is metrics?

7 Answers   TCS,

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,

---

what is custom sorting?how we can do this expalain with procedure???

2 Answers   Keane India Ltd,

---

How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,

---

Explain what are the steps to be taken to schedule the report?

0 Answers  

---