Perform the following additional steps while configuring a report in Canvas Studio:
Click the Data Source Name field and select the table datasource that is corresponding to the created stored procedure. In this example, SUMMARY_DETAILS is chosen as the datasource.
- Click the Pre Hook Procedure DS field and select the datasource for stored procedure.
- You can also set the default procedure parameters for filtering data by clicking the Default Configuration tab.
- Click the Procedure Parameter icon and a Procedure Parameters Configuration window appears.
- Set values for the procedure parameters.
- Click outside the window to save the parameter values.
A toast message with a success message is displayed on the screen. - Click Save to save the configurations for the report.
- Generate the report at Sigma. Refer Generating Simple Report in Sigma for more information on generating a report.
The following screenshot shows the generated report with the applied procedure filters during configuration:
...