Configuring Stored Procedure for a Report

Owned by Mahisha Chandrakumar CTOO (Unlicensed)
Last updated: Dec 29, 2021 by Lakshminarayanan1 S CTOO (Unlicensed)

Perform the following additional steps while configuring a report in 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.



  2. Click the Pre Hook Procedure DS field and select the relevant stored procedure datasource.



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



  4. Click the Procedure Parameters option to define the procedure parameters for the report..



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



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



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



  7. Click Save to save the configurations for the report.



  8. Access the 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.



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

     

  10. Click Run to generate the Summary Procedure Report in the selected PDF format. Refer Generating Simple Report in Sigma for detailed information on generating a report in Sigma Application.



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

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.