Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To warehouse Aeros LIVE projection data, we will need:

  • An Aeros Live installation, of at least version 1.47.11.0 or greater

  • A designated data warehouse database with certain tables and procedures (described below)

  • CONNECT permissions for creating and scheduling automated processes

  • An installed CONNECT Scheduler Service, if we wish to schedule execution of warehouse batches. 

Configuration

Warehousing projections is an update to the Data Warehouse 1.0 Database, so we'll need a version of that which includes the "Process", "Process_Batch" and "Process_Message" tables. The Process table will need a new record of Process_Key 5, and like other import types before it we will use the Process_Start column to identify the

...

first week-ending date

...

 that we will calculate batches for. 

View file
nameHouse Dataset Calcs.xlsx