When you import your metadata from a relational data source, you can also import stored procedures. The Framework Manager only supports the import of user-defined stored procedures. When you have imported your stored procedure, you can treat it as if it were a database table and can create joins to other objects.
You can import your stored procedures as part of the initial import of metadata or at a later time. After importing your stored procedure into the Framework Manager, the procedure must first be run in order to get a description of the result set that the procedure returns.
There are certain rules that imported stored procedures must follow for them to work with the Framework Manager:
The stored procedure must return a single result set. The Framework Manager only supports the first result set that is returned.
If the procedure could conditionally return a different result set, then any result set returned should be in the same form, with the same number,...