Page Comparison

For the given sample SWIFT MT940 report, we need to create the datasourcesa data source. Let's assume there are two datasources in Studio for the STATEMENT MASTER and STATEMENT TRANSACTION tables. We need to aggregate these two datasources using the primary key-foreign key relationship. Here, the two tables are related by the ACC_IDENTIFICATION fieldthat we need to create a data source to fetch data from the particular table (MT940 table). Let's create a data source, pointing to the mentioned table, so as to fetch the data for configuring the SWIFT MT940 report.

Perform the following steps to build  configure the data source aggregator for combining the two datasources to fetch the relevant data for creating the SWIFT MT940 report in Sigma Studio:

1. Click Data BuilderRight-click an existing connection and select the Create Data Source option.

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

   Image Removed
   A page appears where the new data source aggregator can be created easily through drag-and-drop.
   Image RemovedImage Added
   
   The Create Datasource page appears.
   
   Image Added
   
   

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.
   Image RemovedSelect Parent Data source from Data Source ID drop-down list, which appears on the right-hand side of the page, e.g. STMT_TRANS_MASTER.
   Image RemovedDrag and drop another data from the left-hand side of the page and connect the parent data source with this data.
   Image Removed

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

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

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

   Info

   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.

   Image RemovedSelect 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.
   

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

   Image Removed
   Click the Save Image Removedicon to save the data aggregatorname in the Data Source Name field, e.g. SWIFT STATEMENT DS.
   
   1. Select the relevant DB table from the Object Name lookup field, e.g. mt940.
   2. Enter the bundle key name associated with the property file in the Bundle Key field, e.g. common. By default, common appears as the Bundle Key.
   3. Select the data columns from the Column IDs drop-down list.

   4. Click Save to save the configured data source.

      Warning
      When you try to exit the Data

   Builder screen

   1. Source screen, before saving the configured data source

   aggregator

   1. , a warning pop-up message appears, as shown in the following screen shot: Image Modified Click Cancel, if you do not want to exit the Data

   Builder

   1. Source screen. Click Ok, if you want to exit the Data

   Builder

   1. Source screen.

   Image Removed

   1. 
      

      Note
      For detailed information on the standard and query-based data sources, refer Create a DB Data Source and Applying parameters for SQL Data Sources respectively.

      
      

   Image Added
   
   A confirmation message appears, indicating a successful save of the configured data source.
   Image Removed
   Image Added
   
   
   
3. Click Ok for the message.

Refer the following page:

...