Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 8863 Views
- Cognizant, WinAlliance, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference between condition & filter?
what are the tables used in health care domain project and columns used in report?
In banking domain how many Fact tables,Dimension table are present?
Explain what is the difference between business requirement document and use case document.
What is a bo repository?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is the difference between user and versatile user?
what is the difference b/w the refresh and buffered data?
Can you please send me the migration related issues .
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What are the steps to do to use alerts in bo?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain about alerts in bos, under what situation we need to use alerts?
