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;
/

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6802

---

Explain what are the measure objects?

958

---

in sap bi we have wad, then why we go for sap bo

3345

---

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4377

---

Explain when we use aggregate awareness function in designer?

993

---

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

964

---

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

1318

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1846

---

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

1110

---

what will be the contents for a functional requirements specifications

2311

---

What is package in BO

3167

---

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

998

---

What is the difference between slice and dice and cross tab report?

1014

---

What is report template in b.o?

980

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3035

---