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
- 8705 Views
- Cognizant, WinAlliance, I also Faced
- E-Mail Answers
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
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain how many universes can be created in a project?
how many reports have u created ? explain a few.
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Differences between business objects and web intelligence reports?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the difference between the public object&schema object?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what are the measure objects?
What are the join problems comes appart from loop,chasm & fan Traps
explain in detail about type 3?
How to schedule the report in b.o?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
