Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 to create metric universe ?

0 Answers   TCS,


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  


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

0 Answers   BMC,


Explain what would you consider as your biggest achievement and why?

0 Answers  


Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers  






Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....

2 Answers  


CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  


Explain is there any other repository domains rather than universe, security, document?

0 Answers  


what is Scope of Analysis

8 Answers   TCS,


what is optional prompt in boxi r2

4 Answers   Mind Tree,


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

3 Answers  


When we use aggregate awareness function in designer?

0 Answers  






Categories