Portal

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 then like the ability to generate a report that shows changes (NEW/UPDATED/DELETED) between two inputted dates - eg today and 6 months ago.

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. 

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.