The kBOS Data Warehouse Module utilise effectively the SQL facilities and consists of three components:

a)     the relational database (Snowflake Schema)

b)     the multidimensional database (Cube)

c)      the presentation layer (Pivot table & Chart)

The ETL (Extract Transform Load) Process is used to:

a)     extract and collect the data/measurements  from the transactional database (core kBOS Database) and selected applications/information sources,

b)     transform / renormalize the data in a comprehensive way and

c)      load/populate (inserts only new data) the snowflake structured database with the data.

The ETL process runs on a scheduled basis when the system is idle and there is no user activity. After the population of the relational database updating of the multidimensional database (Cube) takes place.

The common kBOS Data Warehouse Model is associated with process information. The common model is then extended with company specific performance measurements that are used by the ABIS application.