Intellect Sigma is a Cloud Native Web Reporting product 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 23.1 release version.

Features in Sigma Studio

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

Establishing a connection with Amazon S3

Sigma enables you to connect with Amazon S3, a cloud-based object storage service where objects in the form of files or folders are stored within the buckets. Buckets are the containers, which comprise the stored objects. The stored objects can be viewed and downloaded from the buckets on the S3 cloud-based storage interface. Using Sigma, you can transfer the configured reports to the specific bucket, present in the S3 storage service.
For detailed information on establishing an Amazon S3 connection in Sigma Studio, refer /wiki/spaces/S2/pages/2973899808.

Establishing a connection with Amazon SNS

Sigma enables you to connect with Amazon Simple Notification Service (SNS) for sending report notifications to report consumers. The appropriate E-Mail IDs of the customers or end users are stored in the form of Topics on the Amazon SNS notification delivery service. Using Sigma, you can send the status of the generated reports to your customers by establishing a connection with the SNS delivery mechanism in the AWS environment.
For detailed information on establishing an Amazon SNS connection in Sigma Studio, refer /wiki/spaces/S2/pages/2973900369.

Applying the SQL Model for query-based data sources

Sigma enables you to apply the SQL Model method for the query-based data sources. The SQL Model is an optional field in the data source creation screen. You can make use of the SQL Model option to assign the default wrapping for the provided query statements. The two SQL Model types are: SQL Wrapper Model and SQL Without Wrapper Model. On selecting the SQL Wrapper Model, the wrapping of the query statements will take place and the filters applied for the queries will get wrapped automatically. This enables the applied filters to get invoked in a wrapped format. On selecting the SQL Without Wrapper Model, the wrapping of the query statement will not take place and it is essential that the filters and sorting are applied individually for each of the sub-queries, which are used within the main query statement. It is necessary that the applied filter and sort queries are individually invoked, so that the nested queries embedded with the relevant WHERE clause fetch the data in a proper way.
For detailed information on applying the SQL Model for the query-based data sources in Sigma Studio, refer /wiki/spaces/S2/pages/2973892920.

Configuring the Applied Parameters for Reports

Sigma enables you to configure the applied parameters for the stored procedure and pre-hook procedure-based reports. With the Params Configuration option in the Report Maintenance tab on the Information Report screen, you can now assign individual rules and validations for the applied stored procedure parameters, which are used to configure the report. You can even apply the custom and default values for the applied procedure parameters, which could be used to fetch the data for the reports. Apart from the specific rules and validation, you can even assign the mandatory filters for the applied procedure parameters.
For detailed information on configuring the applied procedure parameters for reports, refer /wiki/spaces/S2/pages/2973904273 and /wiki/spaces/S2/pages/2973903862.

Generating Forms for the Data Sources

Sigma enables you to generate forms for the configured data sources. Using the Generate Form option, you can generate forms for the configured data sources. The forms can be generated for the table, view and query-based data sources as well as the web service and JNDI-associated data sources. But the forms cannot be generated for the stored procedure data sources, as the Generate Form option does not support the creation of forms for the stored procedures.
For detailed information on generating forms for the configured data sources in Sigma Studio, refer /wiki/spaces/S2/pages/2973892920.

Environment Options

Sigma enables you to configure the environment options for controlling the positions of the configured components in your end application and additionally, you can adjust the positions of the context menus, toast messages and other configurable actions which facilitate the application usage. Using Sigma Studio, the environment options can be easily configured in accordance with your needs and requirements. You can view the assigned values for controlling the positions of the configured components by accessing the browser console from the web page of the Sigma Application.
For detailed information on configuring the environment options in Sigma Studio, refer /wiki/spaces/S2/pages/2973926260.

Configuring the Applied SQL Parameters for Reports

Sigma enables you to configure the applied SQL parameters for the reports. With the Params Configuration option in the Report Maintenance tab on the Information Report screen, you can now assign individual rules and validations for the applied SQL parameters, which are used to configure the report. You can even apply the custom and default values for the applied SQL parameters, which could be used to fetch the data for the reports. Apart from the specific rules and validations, you can even assign the mandatory filters for the applied SQL parameters.
For detailed information on configuring the applied SQL parameters for reports, refer /wiki/spaces/S2/pages/2973904516.

Client Grouping

Sigma enables you to configure the clients into groups in Sigma Studio. The main benefit of Client Grouping is that several clients can be grouped together, thereby making it easier to generate reports that are for the clients in the group. Once several clients are grouped together, all reports for those clients in the group can be generated by executing the group instead of generating those reports separately.

For detailed information on configuring client groups in Sigma Studio, refer /wiki/spaces/S2/pages/2973925010.

Compare Database Schemas

Sigma enables you to compare two database schemas in Sigma Studio. You can compare and synchronize two database schemas across two different environments, such as testing or UAT. You can compare both the Data Definition Language (DDL) and Data Manipulation Language (DML) changes between the two schemas and download the queries that pertain to the differences between the schemas.

For detailed information on configuring the compare database schemas options in Sigma Studio, refer /wiki/spaces/S2/pages/2973901155.

View Report Filters in Generated Reports

Once the report is generated in Sigma Application (portal), you can now view the filters and their values that were used for report generation. To view the report filters, just click the report filters icon in the Generated Reports tab.

For detailed information on generating a report in Sigma Application, refer /wiki/spaces/S2/pages/2973926628.

Report Bursting

Sigma Studio users can now schedule and distribute reports to various clients. Report bursting enables you to schedule and distribute single or group report to multiple contacts and contact groups. Each recipient gets a subset of the report data related only to them.

For more detailed information refer /wiki/spaces/S2/pages/2973914561.

Sigma Audit Log History

Sigma Studio administrative users can view the users’ activity history during a specific time period in both Sigma Studio and Sigma Application.

For more detailed information refer /wiki/spaces/S2/pages/2973926421.

Criteria Grouping

In Sigma Studio, you can now:

...

To know more detailed information refer /wiki/spaces/S2/pages/2973925337 and /wiki/spaces/S2/pages/2973925430.

More Information in Generated Reports Tab

Sigma Application users can now view more information about incremental reports and report schedules in the Generated Reports tab.

...

For Detailed information on viewing reports refer /wiki/spaces/S2/pages/2973931241.

Join Types in Data Builder

Sigma enables you to aggregate different data sources using three types of join operations in Studio:

...

For more details on configuring Joins in Data Builder refer /wiki/spaces/S2/pages/2973911370.

Conditional Drop-down Filters for Reports

Sigma Studio users can now configure Drop-down filter that display values based on another drop-down filter value.

For more details on configuring dropdown for the filters refer /wiki/spaces/S2/pages/2973903616.

Refer the following pages: