Ticket fields in Data Warehouse

Depending on the licensing, the administration of ticket fields is called up under Settings > Business Intelligence > Ticket fields in Data Warehouse.

An important task of the data warehouse is to store data for analysis in a separate database. This is done by extracting the data from the 446 Plattform®, its transformation and loading it into the data warehouse (ETL process). A generator of the BI module automatically mirrors data. This reduces the load on the productive database.

Unlike the Dashboard Dashboard is an application, used as a secondary desktop for hosting mini-applications known as widgets. These are intended to be simple applications that do not take time to launch. Dashboard applications supplied with macOS include a stock ticker, weather report, calculator and notepad; users can create or download their own. [Wikipedia] or Reports, this is not a visualization option, but a new data source. You need a tool to visualize the data (e.g. Excel). However, BI data can also be used in reports. The data warehouse is therefore a supplement to the evaluation options.

The data warehouse offers the following advantages and possibilities:

  • The data is always separate from the live database, i.e. queries do not affect productive operation.
  • The queries run very efficiently, since the data are already aggregated according to many criteria.
  • It is possible to access historical data, since an image is stored with each transformation.

Restrictions:

  • A separate server is required.
  • Due to the system, the data is not always up-to-date, since the transformation takes place once a night by default.
  • The data is limited to what the data warehouse offers. For further information, the generator must be adapted or extended.

 

Selection of ticket fields

The list of ticket fields allows you to adjust the field name and the type of use in the data warehouse. From the large number of ticket fields, only those fields that are directly required for mirroring can be selected.

To change the field name, select the corresponding cell and enter a new name.

For use in the data warehouse, you can choose from five options that appear in a drop-down list when you select the cell:

Changed and unsaved cells are marked with a red triangle in the upper left corner.

After saving, the selection is removed and the data can be used for evaluations after an appropriate formatting.