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 implement LDAP authentication in BOE

1 Answers   Infosys,

---

which is the best way to resolve loop context r alias why?

3 Answers  

---

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  

---

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

0 Answers  

---

is there any limit for rows and columns in cross tab

4 Answers  

---

how u link universes of same functional domain ?

2 Answers   Business Intelligence Analytics, IBM,

---

am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

---

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

---

how we send repotrts/documents to end user

2 Answers   HP,

---

Can we have multiple domains?

3 Answers  

---

How do u Receive requiremnts from the client?

3 Answers  

---

What is sdlc in bo?

2 Answers  

---