The analyst should always be able to see the timestamp of when the data is extracted from the source system. This is especially important in validation processes, but also as metadata information during analysis.
Using Business Unit one could make use of the DW_TimeStamp field. This does not exist in ODX.
Technically, one may copy the SQLLite backlog file and extract ODX execution information into DWH. However this would require considerable effort as one would have to set up a task (e.g. batch script) to regularly copy the SQLLite backlog file, make another TX connection to it and merge the data in the DWH.
Adding a DW_TimeStamp on ODX tables would be ideal. Other solutions could be to make the ODX execution details more accessible, e.g. as a table in the ODX.
(Ticket #21213)
