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

What is the difference between datawarehousing and businessintelligence?

8


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1146


How to schedule the report in b.o?

8


what is document design in boxi,have u participate in that

1068


explain in detail about type 3?

7






Explain what are the steps to be taken to schedule the report?

7


in sap bi we have wad, then why we go for sap bo

2025


can anybody tell me about complicated object you have created

2056


is it possible to export the webi reports to crystal reports?with out using businessview?

1168


What is package in BO

2023


Explain what three things do you consider to be the most important factors for a manager?

5


What is thumbnail?

7


What are the data types present in bo? What happens if we implement view in the designer and report?

9


Explain what is the difference between business requirement document and use case document.

9


Explain what task is 98% of the required work of a business analyst?

7