Report to display data returned from stored procedure

building reports webintelligence
1

Hi all,

I am using BO XI R3 and Oracle database. I need to display the data returned from a stored procedure in the report. Please can you suggest me how do I implement this.

  1. Can I directly call an oracle stored procedure from a WebI report?
    or
  2. Should I use a stored procedure universe and then create the report based on this universe? In this case how do I get data from other tables as well?

Thanks,
Ash

ash555 (BOB member since 2009-03-24)

2

It depends if your stored procedure is returning a table, then its better to create a universe on it and then build reports off this universe
Or if the SP is just updating some tables then go for the report directly

Though I havent actually build any stored procedure universe in XI 3.1, its just a thought

.

haider :es: (BOB member since 2005-07-18)

3

Thanks Haider…

If you have any clue as to how to call the stored procedure directly from the report, please can you share it. When i try to give the following syntax in the custom sql of a report, it gives an error saying “Invalid SQL”.

begin
abc;
end;

abc is the name of the stored procedure.

Thanks in Advance,
Ash

ash555 (BOB member since 2009-03-24)

4

Read this post

.

haider :es: (BOB member since 2005-07-18)

5

I am using Oracle database and I am not able to find any such parameter as given in the post in the sbo files. I used the sntax

set linesize 1000
/select * from abc/
exec testproc

But when I validate this SQL, it gives me “SQL contains 0 instead of 1 columns (WIS 10810) error”. If anyone has used the stored procedure in BO XI R3 from an Oracle database, please let me know how to implement it.

Thanks,
Ash

ash555 (BOB member since 2009-03-24)

6

It would be better if you post this query in the same thread with the link provided

.

haider :es: (BOB member since 2005-07-18)