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.