How to work with Store Procedures?

building reports webintelligence
1

Hi,

How to deal with the report migration if the report is having store procedure from 6.5 to Xi R2 .
I am doing DeskI 6.5 To Xi R2 Deski and then using Report Conversion Tool to convert into WebI.
But I am facing issue at Desktop itself. The reports having SP when opened in XiR2 , only the Template is coming no data is there. What needs to be done?

Some reports with out SP also its not getting converted into WebI.Its using the same Universe but two or more queries are there.

We can not use SP as Data providers in Webi, How to convert these reports?

Can Someone Please through Light on this Issue. It will be great help for me.

Thanks

pavan024 (BOB member since 2006-09-19)

2

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)