Service Order

The Service Order fact includes measures based on Service Orders (tssoc200).

Transformation of extracted data:

Deleted lines
Deleted service orders are stored in the Service Order fact table. Deleted service orders are available for analysis. However, service orders with status free that are deleted, are hidden in the fact table and not available for analysis.

This diagram shows the star schema:

Service order star schema