Data Consolidation on any Structure Type
SERAM allows to define and use any number of structure types. The primary structure type is typically the Organization. Other commonly used types are Geography, Finance Code, Site Type etc. The nodes of one structure type can be linked to the node of another structure type, thereby defining a graph.
By using the Change Root Structure functionality of the Data Grid, data can be consolidated and analyzed by following the links to the source of the data. For instance, with the example aboxe, choosing the Geography structure type one would see the data of Site A1 and B1 in the country Austria; in the same way any other site would be consolidated on the respective geography structure it has been linked to.
This allows to see a breakdown of the data in a different perspective. For instance, how do the different geographical regions compare with their CO2 efficiency? Which site type has the lowest or the highest amount of dickness days per employee? This type of questions can be answered immediately by using this feature.
And of course the Drill Down feature is also available when looking at values consolidated uwing a different structure type.
Data Grid Example
The following is a selection of data from the SERAM test dataset. Three sites, each of which is linked to a distinct country which has no other sites, have been selected, as well as the other structures up to the top level of the selected structure type.
By looking at the numbers, it is evident that the top level total and the figures of the distinct countries (having only one site each in this data set) are identical in both examples. However, the consolidation takes a completely different path, and gives the corresponding results along the way.
- Verifying or Analyzing Data
- Organization and Structures