This article will discuss the general principles of programming with Wonderware Intelligence software.
It is very important to develop Intelligence objects as they will sort and contextualize your original data to save the result in a database.
In this case you can easily create your dashboard with the information you want to display.
For example, a company has several textile production plants worldwide and would want to know the alarms in these plants, for each country.
Every alarm is stored in a SQL database.
A Text file referencing the name of the plant and the name of the corresponding country.
The dashboard created is as follows :
In order to obtain this result, we will use intelligence software to prepare the data and aggregate them from different sources (SQL database, text file) and make them available.
The first step is to define the two datasources :
- One for the text file
- One for the SQL data.
These datas will be used in the dashboard. So, we create instances and set some parameters.
The second step is to define the dimension that will represent the context of the dashboard.
In our example this corresponds to the list of countries contained in one of the data sources. So, we create instance and settings.
The last step is to create the measure we want to display in the dashboard.
In our example it is the sum of alarms distributed in each country. For this we will use the dimension that we just created grouping countries and the information from the data source linked to the SQL database. So, we create instances and make some settings.
Once the instance is deployed, a SQL table will be generated with all the values available. It will to connect to the SQL table from the dashboard as to create the desired graphics.
In only a few minutes we have created an object with intelligence software that helps to contextualize and make data available to then display them in a dashboard.
In our example, we could view the alarms according to time of day (morning, afternoon, night).
For this, we should contextualize the data for display based on a time period.
But, how to create data that is linked to time period?
The next article answers this question.