Service Contract Change

The Service Contract Change fact includes measures based on Contract Changes (tsctm320).

Transformation of extracted data:

Latest Change

Only the latest change is available for analysis.

Deleted lines

Deleted service contract changes are stored in the Service Contract Change fact table. Deleted service contract changes are available for analysis. However, service contract changes with status open that are deleted, are hidden in the fact table and not available for analysis.

This diagram shows the star schema: