Migrating DESKI Reports (Stored Procedures) from 6x to XI 3.1

[Former Member]

I am migrating DESKI reports based off of Stored procedures from a 6x environment to XI 3.1

I have created a new OLE DB connection pointing to the new SQL server.

I need to find out how to point my report to the new connection.

I have seen in that in case of DESKI reports using universes, I can go to Data Manager --> Definition tab and point to my new universe there.

But in case of stored procedure report, that option is not available.

Can someone let me know how to go about migrating these reports which are pointing to Stored Procedures.

Thanks

[Former Member · Accepted solution]

Note that I have never done it.

But I heard you could create a new universe with a derived table. In the SQL of the derived table you can call the stored procedure. The connection of that new universe is your stored procedure connection.

Build you report with that new universe, using the derived table.

[Former Member · Accepted solution]

Thanks Aude. I will give that a try and update the post.