ReportSX
If the status of the definition (container) record for the specific benchmark is changed to the configured statuses, the ReportSX is launched. After launch, the following steps are processed:
Data is filled in configured fields at data level.
Fields are filled based on SQL queriesin field.Properties in the Aggregation properties business object.
Sum fields are processed.
If certain fields are configured for aggregation, the values of the child fields are added to the parents. If a certain field is not configured to be updated, it will not be changed in an update situation (record already exists).
Clean up existing details level business object records.
Before the details level records and fields are filled, it starts with deleting the already existing records. There is a configuration that this is only performed for the details level records that are not linked to a data level record that is flagged for not updating.
Details level business object records are added and fields are filled with data.
The details level records are added and the fields are filled as configured.
The status of the definition (container) level business object record is updated.
After a successful calculation of data the status of the definition (container) level business object record will be changed. If the processing by ReportSX is not successful, an error pop-up will be displayed. Finally, logging of the run is performed in the Comment field of the definition (container) level record.