Stored Procedures

[Teresa Pringle]

With Yellowfin you can connect to stored procedures running on your application database.

1. To connect to a stored procedure select the stored procedure options from the create view drop down list.
   
2. Select the Database and then the stored procedure you wish to connect to.
   
3. Click the next arrow to continue to the stores procedure parameters page. Yellowfin will automatically detect parameters which exist in your stored procedure and display this list on the page.
   
   

   

   Connect to Stored Procedure

   01.png (10.38 KiB) Viewed 182 times

   
   
4. You must either mark a parameter as a return field or fill a value for the parameter for non-return fields. The value is only used to return columns at this stage of the view builder. (The non-return fields will become automatic filters on the reports created from this stored procedure).
   
   

   

   Parameter Settings

   02.png (24.76 KiB) Viewed 182 times

   
   
5. When you have completed the parameter section click accept to return the list of fields in the result set.
   
6. Complete the metadata as you would for a standard view. Note that the non-return parameters exist as filter fields.
   
   

   

   Metadata Settings

   03.png (27.82 KiB) Viewed 182 times

   
   
7. Filters will be added into each report created from the stored procedure automatically. They will not be visible on the report data page but will be displayed on the report filter page.
   
   

   

   Filters

   06.png (16.14 KiB) Viewed 182 times