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

Explain what is the difference between business requirement document and use case document.

1026

---

How to schedule the report in b.o?

1043

---

What is the difference between condition & filter?

1466

---

Did you face any problems while creating reports? Name? Solutions?

3694

---

Explain about alerts in bos, under what situation we need to use alerts?

1056

---

what will be the contents for a functional requirements specifications

2358

---

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3478

---

Can we Save (save as) WEBI Doc as DESKI?

8181

---

What is object stores?

992

---

What is thumbnail?

975

---

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

1051

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1271

---

Explain is data mart?

1027

---

What is the difference between the public object&schema object?

1074

---

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

1065

---