SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 59248: How to disable filtering in SAS® Visual Scenario Designer for SAS® Event Stream Processing output windows

DetailsHotfixAboutRate It

In SAS Visual Scenario Designer, you can deploy a deployment to a SAS Event Stream Processing server. The SAS Event Stream Processing model displays the final output windows that contain events where the value of the action variable(s) is greater than 0. Also, the final output windows are connected to any downstream windows. This behavior is the default in SAS Visual Scenario Designer.

image label

However, there is no option to disable filtering of the SAS Event Stream Processing output windows from SAS Visual Scenario Designer.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you apply the hot fix, you need to take an additional step. Run the following SQL query for the SAS Visual Scenario Designer table:

INSERT INTO vsd_app_config_lkp (property_id, "property_nm", "property_value", "property_datatype", sort_order) VALUES (next row number, 'FILTER_ESP_OUTPUT', 'N', 'CHARACTER', 1);

The next row number value refers to the vsd_app_config_lkp table.

After you apply the hot fix and perform the additional step, a filter-output window is created. However, the filter is not applied, and therefore, does not affect downstream windows. This setting allows null and zero values to be included in the Event Stream Processing model-window output.

Example: If FILTER_ESP_OUTPUT is set to 'N', then the filter-output window is not connected to downstream windows.

image label

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual Scenario DesignerLinux for x646.3_M1
SAS SystemSAS Event Stream Processing EngineMicrosoft® Windows® for x643.2
Linux for x643.2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.