We are working on the migration of crystal reports to Business Objects XI R3.1. In crystal reports the Stored procedures were used for data connection. While migration shall we make use of stored procedures to construct the universe. Is there is any constrains of using Stored Procedures while constructing the universe. As the stored procedure is too complex(contains joins , temp tables to insert and update) its too tough to convert the stored procedure to single select query to construct the derived table.
Kindly suggest with the best practise of conversion.