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).
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.
|Is This Answer Correct ?||7 Yes||0 No|
What is the difference between datawarehousing and businessintelligence?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How to schedule the report in b.o?
what is document design in boxi,have u participate in that
explain in detail about type 3?
Explain what are the steps to be taken to schedule the report?
in sap bi we have wad, then why we go for sap bo
can anybody tell me about complicated object you have created
is it possible to export the webi reports to crystal reports?with out using businessview?
What is package in BO
Explain what three things do you consider to be the most important factors for a manager?
What is thumbnail?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain what is the difference between business requirement document and use case document.
Explain what task is 98% of the required work of a business analyst?