what is the necessity of oracle for business objects,why
the interview panel is concentrating on oracle very much?
Just we need the commands using select,joins? why they r
asking about cursors,triggers etc..can any body answer
me ..........Thanks in advance prakash
- 2 Answers
- 5249 Views
- I also Faced
- E-Mail Answers
Answer Posted / saichand
Actuaaly for any BO Developer optimum level of SQL knoledge
is necessary.Because In BO we are moslty using oracle is as
database.so what ever you are selecting in the query panel
it is fired on the database in the form of query.All of us
know it is done by designer automatically.But in some
scenarios we have to iplement freehand SQL quries,derived
tables to get our target results and some times we have to
validate the background SQL generated by BO to undrestand
how results are coming in.And in creation of formulas and
variables we need SQL knowledge.
(to_char,to_date,trim,decode,sign,union,union all....)
so SQL is must.Coming to the PL/SQL in some situations when
the data is in huge amounts,normal sql not meet the
required performance.So we have to use PL/SQL.So it is
required in rare cases where you are uplaoding the data in
tthe report automatically by running the Uniox batch or
gatting the hhuge amont of data in to the reports.
As per my knowledge in real time it is better to know abot
the writing the procedures,creating the views are more
enough.
i think cursors,triggers etc.. are used depend upon data
needs.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to generate the report from excel sheet?
Explain how to schedule the report in b.o?
how to create reports on screech?
What is the difference in creating filters in designer and business objects?
How can you first report in Business Objects by using broadcast agent?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What is difference between webi and infoview?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain is there any other repository domains rather than universe, security, document?
Which versions are used in the bo dashboard work?
