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 to create metric universe ?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what would you consider as your biggest achievement and why?
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
Explain is there any other repository domains rather than universe, security, document?
what is Scope of Analysis
what is optional prompt in boxi r2
which is the best way to resolve loop context r alias why?
When we use aggregate awareness function in designer?