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 particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
how to find the size of the report
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
What is diff between InfoView and Zero BOAdmin (ZABO)?
1.what is context? How u create? With example.
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what is fantrap and chasmtrap ?
what is difference between Rich client web intelligence and Boxir2 web intelligence
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
WHAT IS SYNCHRONIZATION IN BOXI?