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: