Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 8660 Views
- Cognizant, WinAlliance, I also Faced
- E-Mail Answers
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
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
what is document design in boxi,have u participate in that
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain how to execute the plsql procedure from the report by clicking with mouse?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what is xcelsius architecture?
can anybody tell me about complicated object you have created
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain about a time when you discovered a more efficient way to do a work task?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the steps to do to use alerts in bo?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
