Modeling time-series data is an import part of any data warehouse. The following section outlines the implementation of time-series data in the ATG data warehouse.

The time-series model view is shown in the figure below. It contains model query subjects based on the database tables described in the Time Tables section of the Platform Database Tables chapter. The model query subjects represent the components of an instant in time.

The time series data is represented by a single dimension called Time. The Time dimension contains four hierarchies, which traverse the month, the quarter, the week, and the hour.

 
loading table of contents...