Answer Posted / vasu

Decode: using for reporting purpose. and it is implemented
by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;

Case : implemented by if & elsif condition. it is using
pl/sql equality conditionality.
Ex : select case job='CLERK' then 'executive' else 'no' end
a from emp;

it is also used for multipul colms & multi conditions.

in above stmt a is reffered alias name.

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3545

---

Explain when to use local filter and when to use global filter?

1332

---

What is difference between custom hierarchy and report based hierarchy?

992

---

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

3038

---

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1115

---

Explain when we use aggregate awareness function in designer?

1013

---

What are the data types present in bo? What happens if we implement view in the designer and report?

1014

---

Explain what is the difference between slice and dice and cross tab report?

1055

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2085

---

explain in detail about type 3?

1001

---

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

2230

---

what is universe null

2405

---

Can you please send me the migration related issues .

2065

---

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

1028

---

Explain in detail about type 1?

1569

---