topic Re: SAS FACT TABLE in SAS Data Management

SAS FACT TABLE

sharon4pal — Wed, 30 May 2018 15:56:53 GMT

Hello All,

I'm new to SAS and I will like to know what kind of data should be in FSC_CASH_FLOW_FACT and FSC_ACCOUNT_EVENT_FACT.

Kindly advise

Re: SAS FACT TABLE

Amir — Wed, 30 May 2018 16:28:12 GMT

Hi,

It's not entirely clear from your question what the context is, so I tried a web search of "FSC_CASH_FLOW_FACT" and one of the links I found was:

https://communities.sas.com/t5/Fraud-and-Financial-Crimes/Where-can-I-find-columns-of-Fact-Dimension-Bridge-and-other/td-p/229064

which might be of some help.

If you need something else then you might need to supply more details for others to respond to.

Regards,

Amir.

Re: SAS FACT TABLE

TomKari — Wed, 30 May 2018 19:42:07 GMT

I'm not sure that this is a SAS question. Typically, a FACT table is a component of a data storage mechanism called a "star schema", which can be constructed using any one of a number of technologies, including SAS. Here's some documentation about them. I should warn you, it is an advanced topic for a novice / non-IT user.

https://en.wikipedia.org/wiki/Star_schema

Tom

Re: SAS FACT TABLE

SASKiwi — Thu, 31 May 2018 07:21:54 GMT

Have you checked the documentation? You need a user name and password to access it but I assume you have one since you have the product licensed:

http://support.sas.com/documentation/onlinedoc/securedoc/index_fraudmmgt.html

Re: SAS FACT TABLE

sharon4pal — Thu, 31 May 2018 07:36:09 GMT

Thank you Amir,

I was just wondering if fsc_cash_flow_fact and fsc_account_event_fact should hold the same data or if cash_flow_fact table should only contain cash transaction data and account event table should contain ALL transaction data including cash related transactions.

Re: SAS FACT TABLE

Patrick — Thu, 31 May 2018 07:52:51 GMT

@sharon4pal

SAS AML questions go better under "Risk and Fraud"/"Fraud and Financial Crimes" to not confuse people who don't know this SAS solution.

The tables you ask about are both from the SAS AML Core data model. The AML documentation would answer your question.

From memory: FSC_CASH_FLOW FACT is for monetary transactions, FSC_ACCOUNT_EVENT_FACT is for non-monetary transactions (i.e. an inquiry).

Re: SAS FACT TABLE

sharon4pal — Fri, 01 Jun 2018 07:19:19 GMT

We did not buy fraud

Re: SAS FACT TABLE

Patrick — Fri, 01 Jun 2018 07:24:26 GMT

@sharon4pal

If these are not tables from the SAS Anti-Money Laundering (AML) solution data model then one would need to know the data model to answer your question.

If these are tables from the SAS AML model then you need to operate under a valid SAS AML license as else I'd assume you'd be in breach of that license.