MEH(Multi Entity History) stores the profile variables in SAS Fraud Management. How do I query on it

[shruti_g0251]

The MEH database has a complex data model. I can see there is data available in FMH_V_DATA, but its difficult to read. Let me elaborate

Let's say over the SFM UI, under User Variable Segments. I have a Customer Segment(V00), this segment has 10 user variables. Now, I want to find the value of these variables for a transaction that sits in TDR(Transaction Data Repository) database. Normally, I'd use the Explore tab but it has a lot of limitations, including the limit of number of visible transactions and the manual addition of columns. 

I can see the MEH database has tables named FMH_l00_DATA_0 etc. but all these tables are empty. Only FMH_V_DATA seems to be populated.

[GarethSnookSAS]

Hello, I would recommend speaking to your technical support team on this matter to understand your specific ask.

A few key items though, we strongly advice not to query the MEH tables.

To find data, the TDR has VXX tables where the snapshot of the user variables at the time of a transaction are kept, e.g. FCM_CCCA stores CCCA transaction data, and FCM_CCCA_VXX stores the user variable data associated to the CCCA transactions.