Problem Note 34452: SAS® Money Laundering Detection code uses ROLE_DESC, which degrades performance
 |  |  |  |  |
Throughout the SAS Money Laudering Detection code there are references to ROLE_DESC="PRIMARY OWNER" in various locations and queries. This might degrade the performance of the software. It would be more efficient to use ROLE_KEY, which is an indexed field.
Note that existing sites will need to add the following INDEX:
proc sql;
CREATE INDEX ROLE_KEY ON MST_BDG.FSC_PARTY_ACCOUNT_BRIDGE
(
role_key
);
quit;
run;
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Money Laundering Detection | Microsoft® Windows® for x64 | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 1.4 | 1.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Money Laundering Detection 1.4 is available at:
http://www.sas.com/techsup/download/hotfix/mld14.html#034452
The code locating the primary owner of an account currently uses the ROLE_DESC in the bridge, which is not indexed. This might degrade the performance of the software.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2009-03-02 10:33:15 |
| Date Created: | 2009-01-12 14:36:52 |