Delete Detection Method (Model Object)

Description

The Property named Delete Detection Method is available when you edit a Model Object. 

It allows activating the delete detection of rows of a Model Object.

Format

The Delete Detection Method is a List of values.

The possible values are:

• None:
  • Delete detection is not enabled
  • If a row is deleted in the source table, this row will stay open, and no delete detection will be appended
• FullSet:
  

• • Delete detection is enabled
  • The source data always contains the full set of data.

• PartialSet:
  • Partial detection is enabled
  • The source data contains a window of the data in which you want to consider deletes (e.g. Budget for current year)
  • Delete Detection Partial Terms Property must be filled with the terms that are used to specify the window boundaries
  • Delete Detection Partial Operator Property must be filled with the operator used to apply multiple Delete Detection Partial Terms (in case there are more than one)
    
• DeletedSet:
  • Delete detection is enabled
  • The list of rows to delete is provided by a table in the source
  • The Delete Detection Source Property must be filled with the name of the Model Object containing the list of rows to delete

Example:

Default Value

The default value for all Model Objects is None.

Impact

Some rows will be logically deleted.

The BG_IsDeleted Default Term is set to 1.