Creating Data Aggregator for Text Template

Perform the following steps to build data source aggregator for creating a text template combining two datasources in Sigma Studio:

1. Click Data Builder.

   The Data Builder menu option appears only when the CONNECTIONS on the left navigation is selected.

   
   
   A page appears where the new data source aggregator can be created easily through drag-and-drop.
   
   
   
   

2. Enter a unique ID and Name for the data source aggregator. Here, DB_BUILDER is used as the ID and Name for the data source aggregator.
   
   
3. Select Parent Data source from Data Source ID drop-down list, which appears on the right-hand side of the page.
   
   
4. Drag and drop another data from the left-hand side of the page and connect the parent data source with this data.
   
   

5. Click the data element and select data source ID from the Data Source ID drop-down list. For example, Statement Transaction is chosen as the data source.

   The Data Source ID selected can either be a database or a web service data source made for the report.

6. Select how the data source should be attached and resulted in accordance with the parent data source.

   • Merge combines the data sources, where the duplicate data items are eliminated.
   • Join combines data based on the following selection:
     • If you click Equi Join, only the similar entries on datasources will be displayed based on the provided key column.
     • If you click Left Join, all entries on the left datasource and matching records from the right datasouce will be displayed based on the provided key column.
     • If you click Right Join, all entries on the right datasource and matching records from the left datasouce will be displayed based on the provided key column.
   • Union combines the data into new rows.

   Similarly,

   • Record displays the selected data source same as the parent data source is displayed.
   • Children displays the attached data source as a child for the parent data source.
   • Object displays the attached data source just as an object.

   
   

7. Select Parent Column and Child Column from the drop-down list. For example, ACC_IDENTIFICATION is chosen as the parent and the child column in this data builder.
   
   

   These will be identified as unique key columns between the two data sources.

   

8. Click Save icon to save the data aggregator.
   
   
   A confirmation message appears.
   
   
9. Click Ok for the message.

Refer the following page:

• Configuring a Complex Report – Sample 1