How to Use Same Parameters for Multiple Data Sources in BoldBI Dashboards
In Bold BI, it’s possible to utilize shared parameters across multiple data sources. This feature is particularly useful when these data sources are stored procedures. By creating a dashboard parameter in one data source, you can use that parameter value in multiple data sources. This allows for consistent data analysis across different sources.
Steps to Use Same Parameter in Multiple Data Sources
- Create the Dashboard Parameter in the First Data Source
The first step involves creating a dashboard parameter in the first data source. This parameter will be used across all the data sources you want to analyze.
-
Use the Dashboard Parameter Value in the Stored Procedure for the First Data Source
After creating the dashboard parameter, you can use its value in the stored procedure for the first data source. This allows the parameter to be recognized and used within this data source.
-
Use the Same Dashboard Parameter Value in the Second Data Source
The final step involves using the same dashboard parameter value in the second data source. This ensures that both data sources are using the same parameter, providing consistent data analysis across both sources.
Note: The dashboard parameters suggestion list will be populated with the parameters of the data sources that are currently available in the dashboard. Therefore, if you need to list the parameters of the first data source in the second data source, you need to add the first data source in the dashboard that you are working on.
Using Shared Parameters in Different Modes
The shared parameters can also be used in different modes such as in a stored procedure data source, initial filters, and in query mode data source. This provides flexibility and a wide range of use cases for the users.
For more detailed information on configuring dashboard parameters, please refer to the Bold BI Documentation.
References
