Answer Posted / judith

Decode
The default operator for comparison is '=',
for e.g select deptno,decode
(deptno,10,'dept10',20,dept20,default)

so if the deptno=10 then the value is replaced by dept10
and so on,

whereas in Case:

we can use any operator other than '=',
for e.g
select deptno,
case when deptno=10 and sal>1000 then 'dept10'
else
'dept20'

Hope the difference is made clear.

Regards,
Judith

What is the difference in creating filters in designer and business objects?

977

---

How to schedule the report in b.o?

950

---

how many reports have u created ? explain a few.

2031

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10252

---

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

2081

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2269

---

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2228

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2127

---

How can you first report in Business Objects by using broadcast agent?

3000

---

What is the functional & architectural differences between business objects and web intelligence reports?

2359

---

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

974

---

Explain the difference between union and group?

1043

---

in sap bi we have wad, then why we go for sap bo

3321

---

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

998

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

983

---