Answer / shiva shankar sheela

Prakash, its good you raisd it, but what ever we do in the
BO it needs to connect to Oracle with the help of queries.
As my experience says, its some times necessary to have the
derived tables to be created which needs SQL knowledge, to
do data validation we need SQL queries.

Answer / 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.

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

---

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,

---

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---

Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier

2 Answers  

---

in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

3 Answers   Accenture,

---

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,

---

1.what is context? How u create? With example.

2 Answers   Polaris, TCS,

---

what is universe null

0 Answers   TCS,

---

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

---

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,

---