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

In banking domain how many Fact tables,Dimension table are present?

8781

---

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

980

---

What is Indexing? how did u implement indexing?

2439

---

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

3680

---

how to create reports on screech?

2536

---

What would you consider as your biggest achievement and why?

991

---

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

1014

---

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

1029

---

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

2652

---

Explain about a task that really tested your analytical abilities?

1231

---

What is top business?

1047

---

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

1017

---

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

1048

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2416

---

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

2328

---