Sigma is an online MIS reporting tool powered by the Canvas Technology Platform. Sigma enables the end-users to generate "on-the-fly" reports just by configuration. Using Sigma, you can generate reports in multiple formats, such as PDF, HTML, DOCX, XML, CSV, and XLS.

The major release notes contain details of enhancements in the Sigma 19.1 release.

Features in Sigma Studio

The newly introduced features in Sigma Studio, as part of this release, are listed as follows:

Select Multiple Formats for Reports

By default, Sigma offers multiple formats for the reports to be generated in the end application. While creating the report in Sigma Studio, you can select multiple formats for your reports. CSV, DOCX, HTML, PDF, XLS and XML are the supported formats in Sigma Studio.
For detailed information on selecting multiple formats for your reports, refer Configuring a Simple Report.

Select Specific Columns for Reports

Sigma enables you to select the columns of your choice for the configured reports. Based on your needs and requirements, you can select specific columns, fetched from the data source to be displayed in your reports. The option, "Select Columns to Display" enables you to select the columns of your choice for your reports.
For detailed information on selecting specific columns for the reports, refer Configuring a Simple Report.

Use Stored Procedures for Reports

Sigma enables you to make use of stored procedures to create reports. You can create stored procedures as data sources for your reports by means of simple and efficient configurations. The Pre-Hook Procedure DS option in Sigma Studio enables you to select the appropriate stored procedure for your report.
For detailed information on using stored procedures for reports, refer Using Stored Procedures for Creating Reports.

Configure Data Entitlements

Sigma enables you to configure data entitlements for your reports. The user groups are simply termed as data entitlements and you can specify the user group of your choice as data entitlements, enabling the selected user group to access the configured report. The Data Entitlements are defined as Product, Sub-Product and Function Codes in Sigma Studio. You can create your own set of user groups as data entitlements with simple and effective configurations in Sigma Studio.
For detailed information on configuring data entitlements, refer Configuring Entitlements.

Filter, Group and Sort Data for Reports

Sigma enables you to filter, group and sort the data displayed in your reports. In Sigma Studio, the options of Select Filterable Columns, Select Groupable Columns and Select Sortable Columns enable you to apply filters, grouping and sorting for the selected columns of your choice in your report.
For detailed information on applying filters, grouping and sorting in reports, refer Configuring a Simple Report.

Configure Custom File Names and Directories for Reports

You can add custom file names and directories to your reports in a viable way. The Report Custom File Name option in Sigma Studio enables you to provide customized file names for your reports. You can provide the file name of your choice for your report. The Publisher Relative Path option in Sigma Studio enables you to provide the directory path of your choice.
For detailed information on configuring customized file names and directories for your reports, refer Configuring a custom file name and directory for Reports in Sigma Studio.

Sigma Application Features

The configured reports in Sigma Studio can be viewed and generated in Sigma Application. With the applied parameters, the configured reports can be generated and downloaded in the applied formats in Sigma Application.
The newly introduced features in Sigma Application, as part of this release, are listed as follows:

Generate and Download Reports

The configured reports with the applied parameters can be generated and downloaded in the Sigma Application. The Customize tab in Sigma Application enables you to generate the reports in a simple and effective manner. You can download the generated report in the applied formats, which were configured during the creation of the report in Sigma Studio. You can find the list of generated reports in the Generated Reports section in Sigma Application.
For detailed information on generating and downloading reports in Sigma Application, refer Generating Simple Report in Sigma.

Grouping of Reports

Sigma enables you to group multiple reports into a single report. While generating the report in Sigma Application, you can make use of the Create New Group feature to group different reports into a single report for your business purposes and requirements. The Multi-Sheet option enables you to generate the report with multiple sheets, based on the selected format of the report in the Sigma Application.
For detailed information on grouping of reports in Sigma Application, refer Grouping Reports in Sigma.

Schedule Reports

Sigma enables you to schedule reports on a daily, weekly and monthly basis. If you schedule the reports on a daily basis, the reports will get generated on each and every day. If you schedule the reports on a weekly basis, the reports will get generated on the selected day of the week. If you schedule the reports on a monthly basis, the reports will get generated on the selected day of the month.
For detailed information on scheduling reports in Sigma Application, refer Scheduling Reports.