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.

WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?

1 Answers  

---

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

0 Answers   iNautix, Wipro,

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

what is document design in boxi,have u participate in that

0 Answers   Accenture, TCS,

---

how many reports have u created ? explain a few.

0 Answers   Bank Of America, TCS,

---

I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,

---

HOW DO YOU SCHEDULE THE REPORTS?

5 Answers  

---

How we can add a comment in universe...?

1 Answers  

---

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  

---

Hi friends, How many types of dimentions are they ?What are they? Thanks in advance

5 Answers   Mind Tree,

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

---