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
- 8783 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
How to generate the report from excel sheet?
Explain when to use local filter and when to use global filter?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can anybody tell me what are the tuning problems?
What is the difference between business requirement document and use case document.
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What would you consider as your biggest achievement and why?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are the steps to be taken to schedule the report?
Explain is there any default username & pwd for bo designer & supervisor?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Can we Save (save as) WEBI Doc as DESKI?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
