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.




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 Help Members By Posting Answers For Below Questions

any difficulitis have you phase while creating bo reports and how did u solve it

2372


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

1741


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1279


8. How much supervision have you typically received in your previous job?

1109


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1084






Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

869


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

3420


U r project in which stage in implementation?

1319


what are the tables used in health care domain project and columns used in report?

3363


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

945


What we need to discuss with designer before starting the universe designing.

1149


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3165


What is the profile and package?

1099


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1084


can anybody tell me about issues faced while creating reports

1000