SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35523: Performance might be poor when issuing queries that use the Fsc_Transaction_View table in SAS® Anti-Money Laundering

DetailsHotfixAboutRate It

You might experience poor performance in the Investigation user interface (UI) with queries that use the Fsc_Transaction_View table. The reason for the slow performance is that the UI adds a JOIN statement to the Fsc_Account_Dim table at the end of the Fsc_Transaction_View query.

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

The JOIN statement has been incorporated into the Fsc_Transaction_View table to improve the performance. The metadata table Fsk_Ui_Column has also been modified to prevent the UI from adding the JOIN statement after the view code.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft Windows 2000 Advanced Server2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled AIX2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled HP-UX2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
64-bit Enabled Solaris2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
Linux2.12.2.19.1 TS1M3 SP49.1 TS1M3 SP4
* 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.