Deletions

If a record is deleted in LN, a record with deleted = 1 is stored in the dimension. Records are never removed from dimensions because historic transactions or other dimensions with references can still exist in the data warehouse.

Degenerate dimension (transaction ID) records are hidden depending on the transaction status.

Examples:

• An order that is planned and deleted in LN, will be hidden in the degenerate dimension. An order that is closed and deleted in LN will not be hidden and remains available for analysis.
• An operation that is not yet completed and is deleted in LN, will be hidden in the degenerate dimension in Birst. Completed operations that are deleted (when archiving orders) will not be hidden and remain available for analysis.