TOPs stage: generates the reporting version of the
TOPs, in order to have a centralized mapping schema
that provides the latest version on the TOPs.
• CarConfig stage: generates the reporting CarConfig
data mart (this data mart serves number of reports for
launch analysis, where the study is only for customers
trends on web “Build and Price” activities).
• Inventory stage: generates the reporting inventory data
mart. The inventory data is a snapshot of the inventory
stock on the cutoff date.
• Order stage: generates the reporting order data mart.
The order data is a snapshot of the dealer orders on the
cutoff date.
• Sale stage: generates the reporting sale data mart that
covers the studied period.
• Final stage: generates the final reporting data mart that
combines all the data marts created previously in order
to serve the Slow Turn/Launch analysis reporting
needs (note that Slow Turn analysis works on OLAP
cubes built above this data mart).