Service Contract Revenue

The Service Contract Revenue fact includes measures based on Contract Installments (tsctm400), Estimated Contract Revenues per Period (tsctm450), and Contract Revenues (tsctm460).

Transformation of extracted data:

Latest Change

Only the latest change is available for analysis.

Deleted lines
Deleted records are stored in the Service Contract Revenue fact table. Deleted service contract revenues are available for analysis. However, Service Contract Installments and Estimated Contract Revenues per Period with status free that are deleted, are hidden in the fact table and not available for analysis..

This diagram shows the star schema:

Service contract revenue star schema