DATA Step, Macro, Functions and more

in Scenario SAS10005 some accounts are getting missed How can we trace back ?

Reply
Frequent Contributor
Posts: 81

in Scenario SAS10005 some accounts are getting missed How can we trace back ?

Hi All,

 

We are facing some issue in Scenario SAS10005 ,how to trace back issue as below :-

 

For  Scenario SAS10005 of 3/4 accounts are missing from our SAS AML system and those are present in FSC_ACCOUNT_DIM , FSC_CASH_FLOW_FACT but still they are not present in FSK_ALERT table .

 

Please help me in this Which all table should I check in AMLCORE, AMLCTR schema.

Respected Advisor
Posts: 4,736

Re: in Scenario SAS10005 some accounts are getting missed How can we trace back ?

[ Edited ]

AMLCORE is your data source. You then join core tables together to create a prep file (party_transactions in your case).

A prep file is your data mart table against which registered scenarios get executed.

 

If for a scenario the selection criteria (the rules) become true then it triggers an alert (=writes data to the output). These alerts then get stored in AMLCTR tables like FSK_ALERT.

 

Sooo... I'm not really sure what you're asking here for. SAS10005 is a Customer type scenario so I'd expect customer alerts and not account alerts. FSK_ALERT should also only contain entities for which an alert has been raised so I'd hope you don't find all accounts and customers in this table. 

 

If you don't get alerts in FSK_ALERT which you'd expect then I'd check the following first:

1. Does your prep file contain these records (=verify that the data prep join logic is correct)?

2. Is the scenario registered against the header so that it actually gets executed?

3. Is the scenario logic correct so that it should generate an alert for a know test case?

4. Are the scenario parameters set to values so that the scenario should fire for a known test case?

5. And last but not least: Are you running for the right date?

Ask a Question
Discussion stats
  • 1 reply
  • 59 views
  • 0 likes
  • 2 in conversation