Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Perform the following additional steps while configuring a report in Canvas Sigma Studio:

  1. 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.

    Image Removed


    Image Added

  2. Click the Pre Hook Procedure DS field and select the datasource for relevant stored procedure datasource.
    Image Removed
    Image Added

  3. You can also set the default procedure parameters for filtering data by clicking the Default Configuration tab.
    Image Removed
    Image Added

  4. Click the Procedure Parameter icon and a Procedure Parameters Configuration window appearsParameters option to define the procedure parameters for the report..



  5. Set In the Procedure Parameters Configuration screen, provide the appropriate values for the listed procedure parameters.
    Image Removed
    Image Added

  6. Click outside the window Save to save the provided procedure parameter values.

    Image Added

    A toast message with a success message info is displayed on the screen.
    Image Removed
    Image Added

  7. Click Save to save the configurations for the report.
    Image Removed
    Image Added
    Generate
  8. 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.

    Image Added

  9. In the Procedure Parameters Configuration screen, define the appropriate parameter values for the listed procedure parameters and proceed to click the Save option.

    Image Added 

  10. 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.

    Image Added

    The following screenshot shows the generated report with the applied procedure filters during configurationas per the provided configurations:

Image RemovedImage Added