Page Comparison

Sigma enables you to display the values from widgets (apps) as report filters by configuring the Linked Widget settings in Sigma Studio.

For instance, a report by applying the linked widget filter appears, as shown in the following screenshot:



To create a report with widget columns configure the additional steps in Sigma Studio:

1. Create an app using App Designer option in Sigma Studio by selecting Classic Grid as the view type and drag and drop the columns from the data source into the column section. Refer /wiki/spaces/CTv21/pages/2160560085 for more information on creating an app.
   
   For example, here ACC_STATEMENT app is created using ACCOUNTSTATEMENT data source in App Designer with ACCOUNT_NO and Auth_id dragged and dropped into the column section.
   Image Removed
   Image Added
   
   

2. Similarly, create a report with the same data source that is used while creating the app.
   Image Removed
   Image Added

   Warning
   It is mandatory to select the same data source that was used while creating the App.

   
   

3. Click the Select Filterable Columns field and select the column(s) by which the report results are to be filtered.
   
   Image Added
   
   
4. Click a column name from the selected filterable columns and the Linked Widget Configuration window appears.
   Image Removed
   Image Added
   
   
5. Click Linked Widget lookup field and the existing apps created in Sigma Studio appears.
   Image Removed
   Image Added
6. Select the app (created in Step 1).

7. Similarly, select a column from Linked Column and Linked Description lookup fields, where the columns of the app appear.
   Image Removed
   Image Added
   

   Tip
   Click outside the pop-up window to save the Linked Widget configurations.

   
   

8. Repeat steps 4, 5, 6, 7, and 8 to link another widget to a column and its column as report filter.
   
   
   • Here, AUTH_ID column from the widget is chosen as another report filter.
   Image Removed
   Image Added
9. Click the Dependency Field and choose the column for which you want to display the secondary filter drop down with respect to the column chosen in the Dependency Field.  
   
   Image Added
   
   
10. Perform the other configurations and save the report in Sigma Studio.

...

1. Select the required report in Sigma Application and in Customize column, click Select Filter drop-down and the filter columns selected in Sigma Studio appears.
   Image Removed
   Image Added
2. Select a column to filter the data set and click the Select Criteria drop-down list.
   Image Removed
   Image Added
3. Select the filter criteria. For example, select the in the list of option.
   
   
   • All the values of the selected filter are available in the REPORT_FILTER_LINK_IN drop-down list.
     Image Removed
     Image Added
     
     
4. Select a value from the drop-down and click the  icon to add the selected filter value.
   Image Removed
   Image Added
5. Repeat the steps 1 , and 2 , and 3 and 4 in order to select the other filter columns.
   
   The values with respect to the first filter selected will be displayed in the REPORT_FILTER_LINK_IN drop-down list.
   For example, the
   
   Image Added
6. Select the value from the drop-down and click the Image Added icon to add the selected filter value.
   
   Image Added
   The following screenshot displays Authentication ID column with the value 'SYSTEM' as another report filter:
   Image Removed
   Image Added
   
   
7. Perform any of the following:

• To execute the report, click Run.
  or

• To create a duplicate of the report, click Save As.
  

  Note
  If you have clicked Save and Run, the generated report appears on the Generated Reports tab.