Business Intelligence Monitoring scenarios are very useful to business users to ensure retrieving up-to-date information from managed systems. By applying a proactive monitoring process, the most important performance data for monitored systems can be centrally displayed along with the progress over time in order to detect the deficiencies as early as possible. This purpose requires availability and good performance of all involved components.
SAP, one of the leading BI vendors, offers a monitoring solution to centrally perform proactive monitoring of BI solution landscape. It is the BI Monitoring application found in Technical Monitoring Work Center within SAP Solution Manager 7.1 and higher and SAP BW 7.0 and higher.
The BI monitoring process basically uses the Extractor Framework (EFWK) to collect configuration data from different sources of differing system types before being transferred to the associated Business Intelligence system. Afterwards, data will be displayed in SAP Solution Manager by means of tools allowing direct access to the data in BI.
Based on the architecture shown above, SAP Solution Manager tries to reduce and centralize the management of SAP system landscape which includes a large number of installed SAP systems (e.g. ERP, CRM, BI and EP). More specifically, Solution manager can easily perform central and real-time monitoring of complex, heterogeneous landscapes, business processes and interfaces.
By using Extractor Framework, performance data from system landscape is written to the SAP BI Info Cubes by applying the ETTL process (Extracting, Transferring, Transforming and Loading Data).Technically, extractors in EFWK move data out of source system (e.g. SAP R/3 system) and transport it to the data warehouse based on a realistic schedule. Meanwhile, data can be cleansed, aggregated or simply enriched with context information (SAP-specific landscape information) so that it can be represented consistently. Furthermore, configuration items, values and histories are stored in the Configuration and Change Database (CCDB) which is part of Solution Manager.
Author- Salma MATOUSSI