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.

how to create metric universe ?

2348

---

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

2397

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1833

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1116

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2005

---

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

1064

---

Explain difference between zabo and webi?

1102

---

How were the reports scheduled and how to resolve unexecuted documents?

2676

---

How to restrict password to a user while sending a document in .pdf format

2349

---

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

5114

---

What is object stores?

990

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2158

---

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

2253

---

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2059

---

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

988

---