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
How to schedule the report in b.o?
What task is 98% of the required work of a business analyst?
What is the difference between slice and dice and cross tab report?
Explain in detail about type 1?
Explain how we drill up week to month?
How many universes can be created in a project?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain the data types present in bo and what happens if we implement view in the designer and report?
how to create metric universe ?
Explain which versions are used in the bo dashboard work?
What is top business?
Explain is data mart?
Explain what would you consider as your biggest achievement and why?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?