Is there a way to return data from a stored procedure in BusinessObjects XI R2
Posted on 2011-04-20
I have an existing stored procedure that was a part of a Crystal Report. I would like to move this to a WebI report, which does not appear to support stored procedures out of the box. I am using an Oracle database, which seems to have some limitations when it comes to views, namely, that you cannot perform DML operations from select statements. That all means that, 1) in order to create my WebI report, I have to have a view (or table) to select from, and 2) I cannot use data manipulation operations to do this, because using a view would require those to be executed in a select statement.
My question is, what are my options? It seems that, with the complexity of a data-warehouse, it's would be difficult to access and manipulate all data in cursors and views. Is there something I am missing, and WebI can execute stored procedures?
Thanks a lot for the advice, I'm new to BusinessObjects, and could very well be missing something very obvious.