Page Comparison

Configuring an incremental report in Sigma Studio

To configure an incremental report in Sigma Studio, perform the following stepsSigma enables you to configure a report with a specific file extension of your choice for the CSV format. You can even select a specific delimiter for the CSV format. Delimiters like comma and semicolon pave the way for the listed characters in the data sets to be distinctively separated in a proper manner. For the CSV format, the delimiters like comma and semicolon logically separate the different characters present in the data sets and the logical sequence of data will be displayed in an acute manner in accordance with the adept usage of delimiters. In Sigma Studio, you can assign delimiters and choose a specific file extension for the CSV format with simple and effective configurations.

To configure a report in the CSV format with a particular delimiter and a specific file extension, perform the following steps in Sigma Studio:

1. On the home page of Sigma Studio, click Create > Report.
   

...

1. 
   Image Added
   
   The Information Report page appears. 
   

...

1. 
   Image Added
   
   
2. Enter a unique ID in the Report Id field, e.g. Transactions ACCOUNT_MASTER.
   

...

1. 
   Image Added
   
   
2. Enter a unique name in the Report Name field, e.g. Transactions ACCOUNT MASTER.
   

...

1. 
   Image Added
   
   
2. Provide the other necessary details for the report, as shown in the following screen shot:.

   
   

   Note

...

1. For detailed information on creating reports,

...

1. refer Configuring Reports.

...

1. Click the selected column in
   Image Added
   
2. In the Select Filterable Columns field to configure incremental reports, 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 Integer. 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.
Image Removed

1. In the Linked Widget Configuration pop-up, enable the Is Mandatory toggle option to set the selected date filter (TRANSACTION_DATE) as a mandatory filter for the configured report.

Image Removed

1. Enable the Is Incremental toggle option to set the configured report as an incremental report.

Image Removed

1. Click the Increase By Unit drop-down list and select the time period Allowed Format field, click the CSV format.  
   
   Image Added
   
   The Configure delimiter for CSV pop-up appears. 
   
   Image Added
   
   

2. Click the Delimiter drop-down list and select the delimiter of your choice, e.g. Comma. 

   Note
   The available delimiters are: Comma, SemiColon, Space and Tab.

   
   Image Added
   
   

3. Click the Text Qualifier drop-down list and select a text qualifier of your choice, e.g. Hour Double Quotes.
4. Specify the number of minutes, hours or days in the Increase By Value field. As the Hour time unit was selected in the Increase By Unit drop-down list, the number of hours is specified in the Increase By Value field, for example: 1.
5. Specify the delay time for the configured incremental report in the Delay Time field, e.g. 10.

...

1. 
   
   

   Note

   Text Qualifiers are used within the delimiters to indicate the beginning and the end of the contents for a particular delimited text value. If the delimited text values are indicated in double-quotes, then the text values placed within the double quotes will not get separated by the delimiter, thereby ensuring that the specified text values placed within the double quotes are considered as a single value.

   
   Image Added
   
   
2. Click the Select File Extension drop-down list and select a file extension of your choice, e.g. csv.
   
   Image Added
   
   
3. On the Information Report page, click Save to save the report. 
   

...

1. 
   Image Added
   
   A confirmation message, indicating a successful save of the report, appears. 
   
   Image Modified
   
   
2. Click Ok. Anchor_GoBack_GoBack