Skip to Content
0
May 19 at 01:41 AM

Appending records

114 Views

Hi Friends,

Business case - data moves from one model (multiple audittrails) to another model (a single audit trail) using destination app. This existing logic works as intended. New requirement is to move data for a single auditrail of source model to the destination model, without overwriting/clearing the existing records in the destination model, something like an append. (special scenario only)

Existing logic

*XDIM_MEMBERSET CATEGORY = ACTUAL
*XDIM_MEMBERSET TIME = %curmonth%
*XDIM_MEMBERSET AUDITTRAIL = BPC_FLAT,BPC_PCT,BPC_JRNL
*XDIM_MEMBERSET RPTCURRENCY = USD, LC
*DESTINATION_APP = Finance
*WHEN CATEGORY
*IS ACTUAL
	*REC(FACTOR=1, AUDITTRAIL=BPC_DISTRIBUTION)
*ENDWHEN

New logic, we just need to pass BPC_JRNL entries to finance as top-side adjustments, is there a way to append the records in the destination model instead of overwrite. With this logic, the total value in audit trail bpc_distribution, gets overwritten by bpc_jrnl.