Dynamically Changing Stored Procedure Parameters in Bold BI Dashboards

Overview

Bold BI allows you to build interactive dashboards where end users can change the input values passed to a stored procedure without modifying the dashboard design. By linking a Dashboard Parameter to a stored procedure parameter, users can dynamically refresh dashboard results directly from the Viewer.

This approach is useful when users need to switch between different business scenarios, regions, departments, customers, or other filter values while viewing the same dashboard.

Prerequisites

• Before configuring dynamic stored procedure parameters, ensure that:
  • A supported database connection is available.
  • The stored procedure executes successfully in the database.
  • The stored procedure contains input parameters.
  • Dashboard Parameters are enabled and configured.
  • The user has permission to access the data source.

Steps to Dynamically Change Parameters

Step 1: Create a Dashboard Parameter

• Create a new Dashboard Parameter of List Type, name it and bind values to the parameter

  • Open the dashboard in the Designer.
  • Navigate to Dashboard Parameters.
    
    

• Choose List as the parameter type.
  

  
  • Enter a name for the parameter.
  • Configure and bind the list values that users can select.
  • Save the parameter.

Step 2: Configure the Stored Procedure Data Source

• Click Add Data Source.
• Select the same database connection used for the Dashboard Parameter.
• Choose Stored Procedure as the data access type.
• Select the required stored procedure.
• Under Parameter Mapping, locate the stored procedure parameter.
• Set:
  • Value Type = Parameter
  • Value = Select the Dashboard Parameter created in Step 1
• Click Connect to preview the results.
• Save the data source.
• 

3: Design and Publish the Dashboard

• Use the fields from the stored procedure data source to design your dashboard widgets.
• Configure any required filters and visualizations.
• Save and publish the dashboard.

After publication, users can change the Dashboard Parameter value directly from the Dashboard Viewer and refresh the dashboard data dynamically.

Step 4: Change Parameter Value in Viewer Mode

• In the Dashboard Viewer, click on the Dashboard Parameter Icon.
• Open the published dashboard in Viewer mode.
• Click the Dashboard Parameter icon.
• Choose the desired parameter value from the Dashboard Parameter Dialog
• Click Apply or OK. The dashboard will instantly refresh, and display data filtered by the new parameter value passed to the stored procedure.

Conclusion

By mapping Dashboard Parameters to stored procedure parameters, Bold BI enables dynamic, self-service data exploration without requiring dashboard redesigns. This approach improves usability and allows business users to switch between scenarios, departments, regions, or customers directly from the dashboard viewer.

Related Articles

• Changing Stored Procedure Parameter Values Dynamically in Bold BI
• How to Pass Parameters to Stored Procedures via Dashboard URLs
• How to Use the Same Parameters for Multiple Data Sources in Bold BI Dashboards
• How to Refresh Data Sources Created with Stored Procedures
• Bold BI – MSSQL Stored Procedure: OpenQuery vs Internal Cache Mode