Asked a question 11 months ago

Is there any built in xDM functionality that allows you to report on data differences between two points in time? Is anyone aware of examples where people have created customised delta reporting? Context is a scenario where we utilise Historisation of our data, we would tehn like the ability to generate a report that shows changes (NEW/UPDATED/DELETED) between two inputted dates - eg today and 6 months ago.


David JonesSEMARCHY TEAM
Technical Client Success Manager at Semarchy

Hi Steve, thanks for your question. Entity-level Historization does not extend beyond showing a single view for a single date/time combo, so unfortunately it wouldn't perfectly fit your use-case. Historization does have a useful function that allows you to see attribute changes organized chronologically under a TIMELINE (pictured below), however, you cannot specify dates. 

Attribute TIMELINE
Attribute TIMELINE

The recommended approach is to use one of the History tables in the database, and use the data there to construct your report. The Golden History is located in GH<Physical Table Name>Master History can be found in MH<Physical Table Name>. Below is an example of records in the GH table, and illustrates how changes are tracked. For ID 10003, the first entry is the delta (New), and the proceeding record represents the most recent change (Updated). GX<Physical Table Name> holds deleted Golden members, while MX_<Physical Table Name> holds deleted Masters. Performing a join between the GH and GX table will provide all the changes associated with a specific record. 

Golden History Table
Golden History Table