Setting Up existing and older OEE data for Demo

This page explains how to use the script Prepare_OEE.sql and how to prepare an already existing OEE demo database for training and demo purposes.

When to use this information:

Use this page when you already have an OEE database with data suitable for training demo purposes, but the data is too old.

Script Usage

This script is included to be used for moving all events forward in time for test/demo purposes. The last event will occur on the specified date and the rest of the events will occur back in time from the specified date and will be available for 3-6 months back in time. For parameter information, please refer to the script file itself, located at \oee\template\oee\Prepare_OEE.sql.