Page Comparison

Canvas enables you to display the values from widgets (apps) as report filter in Sigma 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 Creating App 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.
   
   
   
   

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

   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.
   
   
4. Click a column name from the selected filterable columns and the Linked Widget Configuration window appears.
   
   
   
   
5. Click Linked Widget lookup field and the existing apps created in Sigma Studio appears.
   
   
6. Select the app (created in Step 1).

7. Similarly, select a column from Linked Column lookup, where the columns of the app appear.
   Image Modified

   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.
   
   
9. Perform the other configurations and save the report in Sigma Studio.

...

1. Select the required report in Sigma and in Customize column, click Select Filter drop-down and the filter columns selected in Sigma Studio appears.
   
   
2. Select a column to filter the data set and click the Select Criteria drop-down list.
   
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_LIST drop-down.
     
     
4. Select a value from the drop-down and click Add.
   
   
5. Repeat the steps 1, 2, 3 and 4 in order to select the other filter columns.
   
   For example, the following screenshot displays Authentication ID column with the value 'SYSTEM' as another report filter:
   
   
6. 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.