Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. On the home page of Sigma Studio, click Manage > Criteria.



    The Criteria page appears.
    Image Removed
    Image Added 

  2. Select the appropriate Product Code from the Product Code drop-down list, e.g. CANVAS.

    1. Select the appropriate Sub Product Code from the Sub Product Code drop-down list, e.g. CANVAS.
    2. Enter the relevant report criteria in the Criteria Type field, e.g. Criteria
    3. Enter the relevant report criteria description in the Description field, e.g. Criteria.  
    4. Select the Criteria Category, e.g. Data.
    5. Specify the number of characters for the criteria value mapping in the Minimum Characters field, e.g. 2.

      Note

      The specified number of characters in the Minimum Characters field will define the number of characters to be specified for fetching the data set values in the Client Criteria Mapping screen. Refer Mapping Report Criteria for detailed information on the Client Criteria Mapping configurations.


      Image RemovedImage Added


  3. Click the Master Ds lookup field and select an appropriate data source, e.g. TRANSACTION DETAILS DS

    Note

    The Master Ds is the data source using which you had already configured a report in Sigma Studio. It must be ensured that you select the accurate data source from which you had created a report in Sigma Studio


    Image RemovedImage Added

  4. Click the Key Column lookup field and select the relevant key column from the selected data source, e.g. TXN_CD (Transaction Code).
    Image Removed
    Image Added

  5. To enable the column labels in the report to which the created criteria will be mapped, select Yes in Show Labels.

    Note

    If the No option is selected in Show Labels, then the column labels will not get displayed in the report. 

     
    Image RemovedImage Added

  6. Click the Display Columns drop-down list and select the columns to be displayed as part of the created criteria.

    Note

    A maximum of five columns can only be selected from the Display Columns drop-down list. You cannot select more than five columns from the Display Columns drop-down list for a criteria.


    Image RemovedImage Added

  7. Click the Client Entitlement Ds lookup field and select an appropriate client-level entitlement data source.

    Note

    The Client Entitlement Ds is an optional field. 

    Image Removed
    Click the User Entitlement Ds lookup field and select an appropriate user data-level entitlement data source, e.g. DATA_ENTITLEMENT_DS

    Note

    By default, DATA_ENTITLEMENT_DS is selected as the User Entitlement Ds. Sigma provides DATA_ENTITLEMENT_DS as the default user level entitlement for creating a report criteria. So, if DATA_ENTITLEMENT_DS is specified as the default User Entitlement Ds, then there is no need to specify the Client Entitlement Ds.   

    Image RemovedImage Added

  8. Click the Add Labels  icon to provide meaningful display names for the selected display columns. 
    Image Removed
    Image Added

  9. Click the Save  icon to save the created criteria.
    Image Removed
    Image Added

    A confirmation message, indicating the successful creation of the report criteria appears.



  10. Click Ok.
  11. Once you create the report criteria, access the Information Reports on the left navigation pane and edit the report created using the selected Master Ds. In the provided example, let's consider that the Check report has been configured using the Transaction Details DS, which was the selected Master Ds in the created report criteria. 



  12. On the Information Report page, click the Data Entitlements  icon.



  13. In the Entitlement Configuration pop-up, click the Criteria lookup field and select the appropriate key column, e.g. TXN_CD

    Note

    The report criteria name is Criteria. The appropriate key column ID is TXN_CD




  14.  On the Information Report page, click Save to save the report. 



    A confirmation message, indicating a successful save of the report, appears.



  15. Click Ok