Backdated Execution

Backdated Execution refers to the provision of retroactive changes to dimensional records after those records have already been processed and loaded into the warehouse. Support of backdated execution is now limited to Rules and Data transformation Objects in OFSAAI.

Support for backdated Execution of Rules in OFSAA work with active records present with in a dimension (data with latest record indicator as Y). However with the addition of backdated execution support, the rule definitions have the flexibility to continue to use the old version of the data (based on start date and end date of records) for historical reporting purposes leaving the changed data in the new record to only impact the fact data from that point forward. This feature is an enhanced capability and the existing way of working on active record continues. The below sections underlines the changes and configurations required to implement this feature.