Page Comparison

Sigma enables you to create reports by combining different datasources data sources using several join operations in Studio. For instance, the following screenshot shows a report, Account Details Report created combining Transaction and Address datasources data sources using join operation:



Perform the following steps in Sigma Studio to combine datasources data sources using JOIN option:

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 the Name and ID of the data source aggregator in the Name and ID fields. Here, ACCOUNT DETAILS is used as the name for 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. For example, TRANSACTION is chosen as the data source.
   Image Removed
   Image Added
   
   
4. Drag and drop another data from the left-hand side of the page and connect the parent data source with this data.
   Image Removed
   Image Added
   
   

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

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

   
   Image Added
   
   

6. Click Join.
   Image Removed
   Image Added
   
   
7. Select a Join optionany one of the Join options. Here, Left Join is selected.If you click Left Join
   
   Image Added
   
   
8. On using the Left Join option in a data source aggregator to configure a report, all entries on the left datasource data source and matching records from the right datasouce data source will be displayed based on the provided key column. For example, consider the report shown on the following screenshot. Here, Account Number 5500000852 is the additional entry on TRANSACTION datasourcedata source. However all entries from the TRANSACTION (left) datasource data source and matching records from the ADDRESS (right) datasource data source are displayed based on the provided key column (Account Number).
   
   
   
   
9. If you click Equi JoinOn using the Equi Join option in a data source aggregator to configure a report, only the similar entries on datasources data sources will be displayed based on the parent and the child column selected. For example, consider the report shown on the following screenshot. Here, Account Number 5500000852, the additional entry on TRANSACTION datasource data source will be eliminated and only the matching data from the two datasources data sources will be displayed based on the provided key column (Account Number).
   
   
   
   
10. If you click Right JoinOn using the Right Join option in a data source aggregator to configure a report, all entries on the right datasource data source and matching records from the left datasouce data source will be displayed based on the provided key column. For example, consider the report shown on the following screenshot. Here, Account Number 5500000852 is the additional entry on TRANSACTION datasourcedata source. Thus the additional entry on TRANSACTION (left) datasource data source will be eliminated and all records from the ADDRESS (right) datasource data source are displayed based on the provided key column (Account Number).
    
    
    
    
11. Select

    In the Join On Keys section, select the Parent and Child columns from the respective Parent Column and Child Column

    from the drop-down list. For

    lookup fields.

    Note
    It is mandatory to select the Parent and Child columns from the respective Parent Column and Child Column key fields in the Join On Keys section. In the provided example, ACCOUNT_NO is

    chosen as the parent and the child column in this data builder.
    Image RemovedClick save ( Image Removed

    selected as the Parent and the Child column. The Parent and Child columns can either be the same columns from the different data sources or different columns from different data sources. It must be ensured that the data sets of the parent and child columns match accurately with each other.

    
    Image Added
    
    

12. If required, you can select the Parent Column and Child Column from the respective Parent Column and Child Column lookup fields in the Filter Mapping section.

    Note

    In the provided example, ACCOUNT_NO and ACCOUNT_NO are the respective Parent and Child columns. The Parent Column and Child Column options in the Filter Mapping section are optional fields. You can make use of the Filter Mapping option, only if you want to map the parent and child columns from the different data sources. The Parent and Child columns can either be the same columns from the different data sources or different columns from different data sources. It must be ensured that the data sets of the parent and child columns match accurately with each other. On making use of the filter mapping option, the data filters will get applied for the selected parent and column child columns, thereby showcasing the filtered data sets of the parent and child columns on using the configured data source aggregator in a report. However, it is essential that you select the Parent Column (e.g. ACCOUNT_NO) as a filterable column while configuring the report using the Information Report screen.

    
    Image Added
    
    

13. Click the Save ( Image Added ) icon to save the data aggregator.
    Image Removed
    Image Added
    
    A confirmation message appears.
    
    
    
14. Click OK for the message Ok.
15. Now, proceed with the configuration and generation of the report. Refer Configuring a Complex Report and Generating Complex Report in Sigma for more information on configuring and generating the report.