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
- 8862 Views
- Cognizant, WinAlliance, I also Faced
- E-Mail Answers
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 |
What are the join problems comes appart from loop,chasm & fan Traps
Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....
define universe parameters?
HOw do u migrate from old version to the new version?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
how to solve the incompatible objects and how they are formed actually.
Who launches the supervisor product in Business Objects for first time?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
what are the all possible reasons of getting partial result on a webi report?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
where are objects are stored ?
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
Teradata 
