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

how many reports have u created ? explain a few.

2072

---

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

996

---

how to create reports on screech?

2536

---

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)?

1149

---

What is top business?

1047

---

What is package in BO

3187

---

How many universes can be created in a project?

1021

---

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2383

---

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2026

---

what is universe null

2405

---

What is the difference between business requirement document and use case document.

993

---

What we need to discuss with designer before starting the universe designing.

2230

---

Can we configure two instances of CMS pointing to two different CMS system databases?

2006

---

how to create metric universe ?

2328

---

Explain what sort of existing documents should business analysts refer to when starting on a new project?

989

---