We have some limitations to use the Stored Procedure in our dashboard. Please find the details below.
1. Performance of Stored Procedure in dashboard is slow when compared with Tables and Views. The reason is, for stored procedure, internally we move the entire records into a temporary table in a SQL connection and then fetch those data for any operation in dashboard. So, the stored procedure will take some time for data migration. But for Tables and Views, data fetching will be done directly from the SQL Server instead of using temporary table. Therefore, performance of using Stored Procedure is slow in dashboard.
IMPORTANT NOTE: In Dashboard Designer, we move Stored Procedure data into temporary table only once and then fetch the data from that temporary table for any operation. But in Dashboard Server, we maintain the temporary table in cache for every 10 minutes, based on this time interval we have cleared the cache then move the Stored Procedure data into temporary table again.
2. Joining operations cannot be applied for Stored Procedure.
3. Stored Procedure that returns only data table as a resultant set are supported in dashboard designer.
4. Stored Procedure having out parameters are filtered out from the dashboard designer view.
This page will automatically be redirected to the sign-in page in 10 seconds.