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 particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?

1 Answers   WinAlliance,


how to find the size of the report

1 Answers  


1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  


Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.

2 Answers   Wipro, TCS,


What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers   Nucleus Software,






1.what is context? How u create? With example.

2 Answers   TCS, Polaris,


I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?

4 Answers   Keane India Ltd,


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,


what is fantrap and chasmtrap ?

5 Answers   Tech Mahindra,


what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,


Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,


WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,






Categories