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

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,

---

what is difference between global filter an query filter in web intelligence?

3 Answers  

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---

what is the diff between etl tool and olap tool

2 Answers  

---

HOW TO HIDE Column in WEBI & DESKI?

6 Answers  

---

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  

---

How can we use multiple data providers in a single report in business objects?

2 Answers  

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,

---

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers  

---

User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  

---

what is incompactabulity error in sap bo

2 Answers  

---