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).
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|
How do u Receive requiremnts from the client?
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?
where are objects are stored ?
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Explain in Detail about Measure Objects? and what is the use of it? How to create it?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
What is a universe?
what is isolated joins in check integrity
how do you give security to universe ?
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
Please send me BO certification details and question papers? this is my mail id: firstname.lastname@example.org