Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Sigma enables you to create reports by combining different data sources using the Union operation in Studio. For instance, the following screenshot shows a report, Account Details Report created combining Accounts and Summary data sources using the Union operation. In the following Account Details Report, the Account Name and Name columns have been mapped and the additional records listed under the Name column will be listed within the Account Name column, as the Column Mapping option has been used in the Union operation for the configured data source aggregator in order to list the all of the account names under the Account Name column for the Account Details report, and as a result, no records or data sets will get listed under the Name column, resulting it to be in an empty or blank state.



Let's see how to configure a data source aggregator with the Union operation in Sigma Studio. Perform the following steps in Sigma Studio to combine data sources using Union 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 actions.



  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, ACCOUNTS_DS is chosen as the data source.



  4. Drag and drop another data from the left side of the page and connect the parent data source with the master data source (ACCOUNTS_DS).



  5. Click the child data element and select data source ID from the Data Source ID drop-down list. For example, SUMMARY_DS 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. Click Union.



  7. In the Union On Keys section, select the Parent and Child Columns from the respective Parent Column and Child Column lookup fields.

    It is mandatory to select the Parent and Child columns from the respective Parent Column and Child Column key fields in the Union On Keys section. In the provided example, ACCOUNT_NO is 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.




  8. In the Column Mapping section, select the Parent Column and Child Column from the respective Parent Column and Child Column lookup fields.

    In the provided example, ACCOUNT_NAME and NAME are the respective Parent and Child columns. The Parent Column and Child Column options in the Column Mapping section are optional fields. You can make use of the Column Mapping option, only if you want to map the parent and child columns from the different data sources. On mapping the Parent and Child columns, the data sets of the child column will also be displayed within the parent 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.




  9. Click the Save ( ) icon to save the data aggregator.



    A confirmation message appears.


  10. Click Ok.
  11. Access the Information Report screen and configure a report with the created data source aggregator (ACCOUNT DETAILS).



  12. Once you configure a report with essential attributes (e.g. ACCOUNT DETAILS REPORT), click Save to save the report.



  13. Access the relevant report (e.g. ACCOUNT DETAILS REPORT) in Sigma Application and click Run to generate the report.



  14. When the report generation status is displayed as Published to Repository, click the Download icon  to download the generated report.



    The fetched data sets of the ACCOUNT DETAILS report are displayed, as shown in the following screen shot:

    In the following ACCOUNT DETAILS report, the Account Names have been listed under the Account Name column, as the report was configured with the Union operation-based data source aggregator. As the Column Mapping option was used in the data source aggregator, all of the Account Names are listed under the Account Name parent column and so the Name child column is left in an empty or blank state, since its additional records too get displayed under the Account Name parent column.


  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.