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
- 8789 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 |
Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan
Can anybody tell me the difference b/w canned and adhoc reporting?.
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
Report have 10000 records,how to restrict the end user to 1000 Records?
Which versions are used in the bo dashboard work?
Explain the SQL Queries activated to data base from Data provider in BO ?
How to make alternative rows red and green in WebI Report?
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
What is the size of data base?
Did you face any problems while creating reports? Name? Solutions?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Teradata 
