Store Procedure Universe

I'm trying to create a Store Procedure Universe in BO XI R3. The store procedure is in SQL Server 2005 and is quite complicated that includes dropping and recreating a bunch of temp tables, doing a bunch of calculations and then finally loading the data in a table. When I try to import the store procedure in the Universe Desiger, I do see that it imports the store procedure in the designer panel, but I do not see any objects it. So basically it looks like an empty class with no objects in it. Has any one faced this problem? If I run the same Store Procedure through SQL server, I see the data set with no problems.