DWH

The data warehouse is a separate database which contains certain data from ConSol CM in a data model tailored specifically for reporting and data analysis purposes. This section describes how to configure and manage the DWH component of the ConSol CM system.

• DWH administration: Describes how to configure and monitor the data warehouse and perform related tasks.
• Cubes: Describes how to configure and manage cubes on the data warehouse database.

📄️ DWH administration

Introduction to the data warehouse in ConSol CM

📄️ Cubes

Cubes are views on the DWH database. A cube consists of a single table which joins all the necessary data for reporting on the cases of a given queue. By default, a cube contains case data. Optionally, contact data can be included as well. The localized names of the data fields are used as column names and for list values to facilitate a user-friendly naming in the created reports.