In Business Intelligence (BI) scenarios it is critical to ensure that end users retrieve up-to-date information from the BI solution. This requires sufficient performance and availability of all involved components. BI monitoring has the capabilities to ensure that the involved technical systems and components are working as expected. The BI Monitoring application is part of the System and Application Monitoring group in the Launchpad of SAP Solution Manager 7.2.
In a typical customer scenario: data from backend systems (SAP ERP) are extracted into data warehouse systems (SAP BW). In the case of SAP BW, this is done via process chains defined in the SAP BW systems. The resulting data is stored within info objects in the SAP BW systems. This data can be viewed by end users via queries or templates which are also defined within the SAP BW systems. In addition, other systems (Business Objects Enterprise / BI Platform Enterprise) can access SAP BW data (directly from info objects or via queries) for producing sophisticated reports. The definition and scheduling of the jobs, process chains, queries and templates is normally directly performed with the help of standard BO or BW tools like the BO Info View / BI launch pad tool or inside the BW transaction RSPC. The main challenge is how to control and monitor BO jobs, BW process chains, queries and templates?
At the minimum, top business critical jobs, process chains, templates and queries should be monitored and an immediate resolution has to be found in case of a problem. In the past, before BI Monitoring, manual monitoring using system local tools had to be performed.
Following are the key questions that arise during monitoring of typical BO BW customer landscape:
BI Monitoring has the capabilities to address the above questions and perform end-to-end monitoring of the heterogeneous BI solution landscape.
Following are the highlights of capabilities offered by the BI Monitoring:
BI Monitoring centrally performs proactive monitoring of Business Intelligence solutions based on SAP BW and BOE XI including BW Process Chain and BOBJ Job Monitoring and Alerting. The BI Monitoring application is part of the Technical Monitoring Work Center within SAP Solution Manager.
To enhance the BI Monitoring functionality we now offer the Data Readiness Monitoring application inside BI Monitoring.
Very often we have the case that end-users who come into the office early in the morning need to know if the application data that was loaded during the night is already available for reporting.
To decide if the data can be used for reporting, we can combine different jobs and process chains which are processed at different times into a scenario. For this scenario we analyze the result of each monitored object (that is already setup in BI Monitoring) and check if a successful run has happened in an acceptable time range. If this is true we say the data is ready for reporting. This is a pure technical decision which means we assume that if the job runs successfully then the content is also correct. Currently we have no option to also check the content (e.g.: data quality) of a job.
Example: Sales data must be available punctually at 08:00 AM in the BW system for reporting. We can check the corresponding ABAP jobs in the source system and process chains in the BW system and if all of them run successfully until 08:00 AM, we say the data is available for reporting.
This information can be shown in the DRM application of SAP Solution Manager 7.2 or sent via e-mail to the business end users.
In SAP Solution Manager Configuration, general setup steps for BI Monitoring Configuration can be performed as guided procedures.
Gives you a short introduction of which steps of the guided procedure have to be performed.
This is a generic step that is available in different flavors for all MAI applications. It contains the following areas:
Allows you to create standard Users in the SAP Solution Manager system. If you use BI Reporting, you need additional standard template users in the BW system/client. If your BW system is in the same client as SAP Solution Manager, the relevant roles are assigned to the standard user in the SAP Solution Manager system.
Allows you to define the scope (=scenario) to be covered by a HANA and BI monitoring scenario. You need to create a new BI monitoring scenario and give it a unique name. Then you can add several technical systems that are known in LMDB to your scenario.
Consists of the detailed sub-steps for the configuration of all BI specific objects to be monitored:
The Data Readiness Monitoring (DRM) application is based on job and process chain data. This data is retrieved by SAP Solution Manager from the Managed Systems; therefore, BI Monitoring must be configured first.
In SAP Solution Manager Configuration, general setup steps for Data Readiness Monitoring Configuration can be performed as guided procedures.