InfoView report using Stored Procedure

[system]

@radhikaw

Hi,

Is it possible to create a report in InfoView (any version) using stored procedures? In other words, I wanted to know if the InfoView report can be created from a stored procedure by accessing it directly (not via a universe built using stored procedures)?

Thank you,
Radhika

A couple of unsupported methods, from previous releases, in these posts here:-

120×120 10.4 KB

Hi guys! today I was lucky and managed to make stored procedures working in WebI. I’m glad to share this ‘know how’ and say goodby to DeskI Change parameter Force SQLExecute in odbc.sbo to Always Add parameter Force SQLExecute = Always into oledb.sbo Create query in WebI with the same structure your SP returns Change SQL to following set nocount on /*SELECT any_field FROM any_table*/ exec your_stored_procedure @prompt('enter value','A',<other prompt parameters>) you can even use tem…

http://www.letslearnbi.com/2009/06/stored-procedure-in-webi-reports-on-boe.html

---

Mak 1 (BOB member since 2005-01-06)