Stored Procedures

The Stored Procedures dialog lets you run predefined database procedures tied to a data model, returning data based on user inputs to populate the visualization.

The menu item appears in the context menu if your Data Model Role permissions allow it.

When to use Stored Procedures

• Performing complex data manipulation: Automate complex data transformations that require multiple SQL statements before opening a visualization. Stored procedures provide an efficient way to bundle and execute these commands.
• Automating repetitive SQL tasks: Automate frequently executed SQL tasks before a visualization opens, reducing manual effort and ensuring consistent results.
• Enhancing performance: Improve performance in some cases by processing data on the database server, reducing the amount of data transferred to the application.
• Securing SQL execution: Control how SQL commands are executed, limiting direct access to data and reducing the risk of SQL injection.
• Parameterizing queries: Accept parameters in stored procedures to dynamically execute SQL queries based on your input or application logic.

Execute Stored Procedures

1. Open a visualization:

   • Choose from the Views, Reports, Dashboards, or Workbooks tab, find your visualization, and click to open it.

2. Display the Stored Procedures:

   • If a data model is configured with a stored procedure to be executed, the dialog appears automatically when the visualization opens.
   • It displays the parameters required to execute the stored procedure.

3. Set values:

   • Parameters: View the list of parameters required to execute the stored procedure and fetch the corresponding data.
   • Input Values: Enter specific values for each parameter that meet the criteria. A prompt may appear beside each input to guide you on acceptable values.

4. Load the visualization:

   • After confirming your values, select Confirm to apply them, or Skip to use the default values.
   • The visualization loads based on your selected criteria.

Stored Procedures properties

Property	Description
Name	View the name of the stored procedure that will be executed.
Parameters	Review the predefined parameters required to execute the stored procedure. All parameters have default values.
Prompts	View available values for each parameter using the button beside the input field.
Don't ask again this session	Save the current parameter values so you don't need to re-enter them during the same session.
Skip	Skip the dialog and use the default parameter values to load the visualization.
Confirm	Run the stored procedure using the current parameter values and load the visualization accordingly.