Service Order Activity

The Service Order Activity fact includes measures based on Service Order Activities (tssoc210).

Transformation of extracted data:

Deleted lines

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

This diagram shows the star schema: