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

What is the difference in creating filters in designer and business objects?

1078

---

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2096

---

Can we Save (save as) WEBI Doc as DESKI?

8294

---

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

2471

---

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

2044

---

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

2724

---

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

1155

---

How to create Index to the table in the universe designer and how it improves the Query performence

2610

---

What is the difference between user and versatile user?

1142

---

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

1070

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2086

---

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1995

---

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

1132

---

Can Bo generates the Report from the cubical data Explain?

2085

---

any difficulitis have you phase while creating bo reports and how did u solve it

3508

---