Answer Posted / reshma

Deepak,
ur answer has helped me a lot.Thanx a tonne. Guys, pls
follow his steps for Creating report using SP:

1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters


Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,
mainly used for returning the CURSOR OUTPUT.
Eg:

CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT
sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
END;
/

Can we create universe with no cache??

2440

---

what will be the contents for a functional requirements specifications

2287

---

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

939

---

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

1017

---

Can Bo generates the Report from the cubical data Explain?

1985

---

Explain what task is 98% of the required work of a business analyst?

1012

---

Differences between business objects and web intelligence reports?

1122

---

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

976

---

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1465

---

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

1966

---

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

1082

---

Explain about a time when you discovered a more efficient way to do a work task?

1086

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

4937

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1090

---

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

---