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.
   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 Column Description lookup fields, where the columns ofthe 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. Perform the other configurations and save the report in Sigma Studio.

To generate the report with the widget columns filters, follow the additional steps in Sigma Application:

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_LIST drop-down.
     Image Removed
     Image Added
     
     
4. Select a value from the drop-down and click Addclick the Image Added icon to add the selected filter value.
   Image Removed
   Image Added
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:
   Image Removed
   Image Added
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.