Migrating the report to WEBI using Stored procedure

Hi,
I need to migrate the report from BO 6.5 to BO XI ( WEB I),
BO 6.5 contains stored procedure as a data provider?
IS it possible to do? :hb:
If yes, How to do? Can u explain me in detail?
Thanks.


Divyasanthi (BOB member since 2007-05-21)

WEBI reports only use Universe as a data provider.

The best way would be to create a view on that stored procedure and place it as an independent view in your universe and create class and objects and then regenerate the report.


monty4u :us: (BOB member since 2006-12-12)

check out this solution
https://bobj-board.org/t/94285
you can use stored procedures in WebI report with prompts, temp tables, etc…


Dmitry Biryukov :switzerland: (BOB member since 2006-10-15)