The minor release notes contain details of enhancements in the Sigma 20.1.10 patch release.

This section summarizes the details of the features / enhancements delivered as part of this release.

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 Create a DB Data Source.

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 Enabling Drop-downs for Stored Procedure Input Parameters and Enabling Drop-downs for Reports with Pre-hook Procedure Parameters.