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, for every UI interaction, we move the Stored Procedure data into temporary table. So the performance of Stored Procedure in Dashboard Server is slow when compared with Dashboard Designer.
For Stored Procedure, Dashboard have some other limitations too.
2. Joining operations cannot be applied for Stored Procedure.
3. Edit connection option is not feasible with Stored Procedure.
4. Stored Procedure that returns only data table as a resultant set are supported in dashboard designer.
5. Stored Procedure having out parameters are filtered out from the dashboard designer view.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|8647||04/05/2018||04/05/2018||Dashboard Platform||Dashboard Datasources|