Page Comparison

In the following example, let's see how to configure an Incremental Report with data filters applied using the Date data type. For incremental reports configured with Date as data filters, the business data of the incremental report will be fetched on the basis of the data filters applied for the selected Date range.

...

1. On the home page of Sigma Studio, click Manage > Report.
   
   
   
   The Information Report page appears.
   
   
   
   

2. Enter a unique ID in the Report Id field, e.g. Transactions.

   Note
   No blank spaces and special characters should be used in the Report Id field. However, you can make use of the underscore symbol.

   
   Image Modified
   
   

3. Enter a unique name in the Report Name field, e.g. Transactions.
   
   
   
   

4. Provide the other necessary details for the report, as shown in the following screen shot.

   Note
   For detailed information on creating reports, refer Configuring Reports.

   
   
   
   

5. Click the selected column in the Select Filterable Columns field to configure an incremental report, e.g. TRANSACTION_DATE.

   Note

   For configuring incremental reports in Sigma Studio, you must select the filterable column with the data type of Date, DateTime or Timestamp. If you select the filterable column with other data types such as string or float, then you will not be able to configure incremental reports. If you configure an incremental report with the Date data type, the report must be generated only once in the Sigma Application depending on the selected date. For instance, if an incremental report, consisting of transactions data is generated in the Sigma Application, then the generated incremental report will only display the data of the transactions that were successfully carried out on the selected date. If the same incremental report is generated again for the same selected date, then the report generation will eventually get failed.

   
   
   
   

   The Linked Widget Configuration pop-up appears.
   
   Image Modified
   

6. Click the Filter Type drop-down list and select an appropriate filter type, e.g. Date.
   

   Note
   The available filter types are: Date, Datetime and Timestamp.

   
   Image Modified
   
   

7. To assign the selected Date filter as the mandatory filter for the configured report, you must enable the Is Mandatory Filter toggle option. However, the Is Mandatory Filter toggle is an optional field.  
   
   
   
   
8. Enable the Is Incremental toggle option to set the configured report as an incremental report.
   
   
   
   

9. Specify the delay time for the configured incremental report in the Delay Time field, e.g. 5.

   Note
   It is mandatory that the Delay Time should be specified in seconds.

   
   
   
   

10. On the Information Report page, click Save to save the report.
    
    
    
    A confirmation message, indicating a successful save of the report, appears.
    
    
    
    
11. Click Ok.