Skip to Content
avatar image
Former Member

Stored Procedure Universe Issues

Working in version 3.1 SP1 Fix pack 1.8 and created some simple stored procedures to use in the universe and everything worked fine but then due to changing requirements added additional logic to the stored procedures (SQL 2005 database) for the report to include additional prompts and mulitple selects within the code. With these changes, have encountered multiple errors when trying to insert them in the universe or when we are able to insert them in to the universe then no data ever returns from the new stored procedures even though correct execute statements are being created on the SQL Server and they work on SQL Server and in other BI tools. Has anyone else encountered this or know of any limitations using stored procedures in universes?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 19, 2010 at 02:27 PM

    We did resolve our initial issue by changing the universe to use and OLEDB connection rather than using ODBC connection as the ODBC connection didn't seem to support temp tables that were added to the stored procedures. We have run in to other issues with stored procedures but haven't seen the issue that you have with the multiple values.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 18, 2010 at 06:59 PM

    I am encountering the same issue. We're using XI 3.1 SP2 and it doesn't seem to allow multiple values within a stored procedure parameter.

    Add comment
    10|10000 characters needed characters exceeded