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 / 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 |
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
HOW TO PUBLISH A REPORT IN BO?
What is self join
How to change font color of values in hyperlinked columns?
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
Explain what is the difference between business requirement document and use case document.
can anybody tell me about issues faced while creating reports
I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help
solve the following loops? dimension table fact table fact table dimension table link will be there between tables?
How will solve a loop caused by lookup table without using alias?
Analysis in business objects?