We are working on a POC for migration of BO 3.1 reports to BI 4.1. These report are the ones that have custom SQL or Free hand SQL. Hence
a direct migration using upgrade tool is not possible. Hence, we have come up with an approach using stored procedure universe. The custom SQL is rewritten as a single stored procedure and the stored procedure is then inserted into the universe using which we create webi reports. Below are the highlights of the work in progress module :
Note: The webi report gets refreshed successfully when the stored procedure returns no data. However, when the stored proc returns data, we end up with the attached error. We checked all the security level at the CMC level. We are the part of Admin Group. So it is not a security issue.