How to create Derived Tables in BO 6.5.4 with columns from
different tables in the universe and how it has to be
joined in the universe? If any one gives us a PPT format I
will be more thankful.






How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and ho..

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 This Answer Correct ?    7 Yes 0 No

Post New Answer




More Business Objects Interview Questions

How do u Receive requiremnts from the client?

3 Answers  


can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  


where are objects are stored ?

6 Answers   Tech Mahindra,


i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,


How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,






Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 Answers  


i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,


What is a universe?

8 Answers   TCS,


what is isolated joins in check integrity

2 Answers   Polaris, Accenture,


how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,


HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  






Categories