# MDA Adapter
The TISGraph-integrated TISGraph Adapter for MDAv2 grants access to data sets(usually time series), comments, statuses and images stored in MDA (see selecting the data source).
By selecting "MDAv2 Time Series" as the data source in the selection dialog, you will be shown an interface consisting of the following elements:
- Filter for the tree view
- Tree view for selecting time series (to the left)
- "Standard" - detail configuration for time series
- "Aggregation" - parsing data, potentially with pre-processing
- "Missings" - configuring behaviour for missing data
- "Many Years" - multi-year statistical values from reference date ranges (long term values
- "Min/Max Filter" - limit data to date/value ranges
All these configurations are stored in the TISGraph Data URL and shown in the "Datasets" tab.
# Detail Config - Chronological
On this tab, you can configure the main time series as well as optionally boundary time series. Adding the latter will prompt MDA to also deliver dynamically generated status. Selection can be performed via the tree view, which can also be filtered for time series, parameters etc.
Interpolation Type is referring to the interpolation strategy to be used for this time series. Typical use cases for this setting are:
- High resolution momentary values: "Linear interpolatable between two values"
- High resolution average values: "Constant values until the next timestamp"
- Boundary values: "Constant values until the next timestamp"
"Detail Config - Chronological" is the same for time-based graphs, bar graphs, interval range graphics and tables.
# Detail Config - Geo
TISGraph allows the creation of georeferenced graphics. A typical example for that is the display of water level measurements in front of a picture of a dam. When creating such a graphic, "Detail Config - Geo" will be shown in the "Standard" tab. It includes a Parametrized section, which allows configuring:
- a Secondary Series
- A X1 Coordinate, e.g. for vertical gauges
- X1/Y1 and X2/Y2 for e.g. tilted gauges
# Detail Config - Parametrized
For parametric graphs, an additional time series must be defined in the Parametrized section.
For min-max graphs, minimum and maximum can optionally be determined by aggregating from the main time series. Simply leave "Secondary Series" unconfigured in that case.
# Detail Config - Box-Whisker
In order to create a Box-Whisker graph, you will also have to enter a percentile value (default is 20):
In contrast to the WISKI-Database, MDA contains no time series with statistical evaluations from measurement time series. Statistical evaluation can, however, be calculated via the TISGraph-MDA Adapter and configured in the "Aggregation" tab. In this example yearly maximum is calculated from weighted daily averages:
- In Pre-Aggregated? you can potentially specify pre-aggregations which are applied on a daily basis.
- Aggregated? specifies the interval over which the aggregation should be performed.
- In Time Handling, you can specify which timestamp should be assigned to the aggregated value. This has a direct effect on the display of the value in TISGraph reports: In the previous example we used Upper Aggregation Boundary in order to insert it at the end of each year (end of year being the upper aggregation boundary).
- Value Handling finally specifies, which statistical evaluation should be performed.
# Weighted Average
When taking into consideration values for a weighted average it is assumed that values are valid until the measurement of the next value. This is equivalent to the interpolation type "Constant value until the next timestamp". The interval between two values is used to determine the first value's weight.
Gaps in the date range are considered to be missing in the timeline and are ignored for weighing and calculation. E.g., if a daily weighted average is to be ascertained, but there is a gap of 2 hours in the graph, the average is instead calculated on the remaining 22 hours.
# Aggregation of Precipitation
Evaluation of rainfall can be done over different intervals. The TISGraph-MDA adapter currently has intervals 0:00 - 0:00 and 07:00 - 07:00 implemented. In "Pre-aggregated?", the 7 AM interval is currently only defined for maximum and sum aggregations.
Currently, when evaluating the 7 AM interval, the interval considered is actually from 7 AM until the first measurement after the following day's 7 AM. This implementation exists for those precipitation data sources which store the last measured value a few seconds after 7 AM instead.
More evaluation strategies for precipitation sensors can be implemented.
In the "Missings" tab, you can configure the behaviour in response to missing and invalid values.
Hide Comments gibt an, ob eine Lückenbehandlung vorgenommen wird und wenn ja wie die weitere Vorgehensweise dabei aussieht.
Hide Status defines if data status is filtered and if yes, what approach is taken.
Hide Existence specifies the duration, after which a period of receiving no new values is considered to be a "hole".
Min. Filling (%) is only relevant for value aggregations. If an aggregation unit (e.g. day in daily weighted average) has a lower percentage of non-hole duration than this value, then the unit as a whole is considered to be a hole.
SCADA Status: status which are to be filtered can be added by clicking on the combo box and selecting a value from the drop down. Values with these SCADA status are considered to be empty instead.
Time Based: In this section you can define the minimum length of what is considered to be a hole. You can define what action to take if the threshold is exceeded or undercut respectively. The options available consist of treating it as a hole, fill the gap by linear interpolation as well as filling it with the closest previous or subsequent value.
# Hole Management Overview
The following table provides an overview how holes are being dealt with by different configurations for "Hide Comments" and "Hide Status".
|Choice||Hide Comments||Hide Status|
|Requirement||*Occurence of faulty value according to "Hide Existence" and "Min. Filling (%)" configuration||Definierte Status treten auf|
|Automatic||Holes are dealt with according to the configuration under "Time Based"||Value is hidden and hole handling occurs according to "Time Based".|
|Always Ignore||No Hole Assignment||Data status is not evaluated.|
|Always a hole||Any missing values are considered holes.||Value is set as hidden and a hole is inserted.|
# Many Years
Under the "Many Years" tab, you are given the option to aggregate daily statistics over pre-defined reference date ranges, e.g. the daily average of air temperature in the time period 1995 - 2015.
The reference period stays fixed to the values set by "From Year" and "To Year". It is independent from the observation range of the TISGraph report. Should the reference period be changed, the "From Year" and "To Year" values need to be adjusted.
Potential development options for this feature could be:
- Evaluation on a weekly or hourly basis.
# Inserting images from MDA
When inserting an image into a TISGraph report and selecting MDAv2 TISGraph Adapter as the image source, you will be presented with the typical MDA tree pane in order to select the image source within it. You can use the filter to help find it easier. If a valid source is selected, the file names of the images are displayed in the lower segment of the tree view, along with a preview to the right.