Perform the following additional steps while configuring a report in Canvas Sigma Studio:
Click the Data Source Name field and select the table datasource that is corresponding to the created stored procedure. In this example, ACCOUNT SUMMARY
_DETAILS DS is chosen as the datasource.
- Click the Pre Hook Procedure DS field and select the datasource for relevant stored procedure datasource.
- 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 Parameters option to define the procedure parameters for the report.. - In the Procedure Parameters Configuration screen, provide the appropriate values for the listed procedure parameters.
- Click outside the window Save to save the provided procedure parameter values.
A toast message with a success message info is displayed on the screen. - Click Save to save the configurations for the report.
Generate - Access the report at Sigma. relevant report (e.g. Summary Procedure Report) in Sigma Application and click the Procedure Parameters option to define the parameter values for the listed procedure parameters.
- In the Procedure Parameters Configuration screen, define the appropriate parameter values for the listed procedure parameters and proceed to click the Save option.
- Click Run to generate the Summary Procedure Report in the selected PDF format. Refer Generating Simple Report in Sigma for more detailed information on generating a report in Sigma Application.
The following screenshot shows the generated report with the applied procedure filters during configurationas per the provided configurations: