Task

Recommended Frequency

Description and Detailed Information

Monitoring in CCMS

Monitor the BI processes

Daily

Using the BI monitor in CMMS, the most important scheduling tools in the data warehouse, the process chains, are integrated into CCMS. This integration allows monitoring and proactive altering using process chains and, as a result, using most EDW processes.

By double-clicking the process chain, you can call the log view for it. From the log view, you can display additional messages for processes included in the process chain, and call process monitors, such as the extraction monitor.

More information: BI Monitor in CCMS

If you want to receive automatic notification of CCMS alerts and do not want to have to check the status manually in the BI monitor in CMMS, you can forward alerts to Alert Management. This allows you to use the Universal Worklist (UWL) for monitoring tasks for example.

Monitoring the consistency checks of the analysis and repair environment

Weekly. Important checks: Daily

Using the BI monitor in CCMS, you can check whether alerts are triggered when consistency checks are carried out on metadata and data from the analysis and repair environment.

More information: BI Monitor in CCMS    

For information on how you can be automatically kept informed using CCMS alerts, see Forwarding Alerts to Alert Management.  

Availability monitoring for UD Connect

You can monitor the availability of the SAP J2EE Engine using the CCMS Alert Monitor. Availability monitoring is performed using the Generic Request and Message Generator (GRMG). If the availability check fails, an alert is triggered in the central monitoring system.

To check whether alerts have been triggered, in CCMS Alert Monitor (transaction RZ20) choose SAP CCMS Technical Expert Monitors  → System / All Monitoring Segments / All Monitoring Contexts  SAP_CCMS_<Application Server>_<SID>_<System Number>

System / All Monitoring Segments / All Monitoring Contexts  → SAP_CCMS_<Application Server>_<SID>_<System Number>. The messages are shown under the node GRMG: BI.UDC: v1.0.0. %SID:%HOST (replace %SID and %HOST with the values for your server).

For information on how to configure availability monitoring, see SAP NetWeaver Customizing at Business Intelligence → UDI Settings by Purpose → Install Availability Monitoring for UD Connect in CCMS.

For information on how you can be automatically kept informed using CCMS alerts, see Forwarding Alerts to Alert Management.  

Monitoring in the Administration Cockpit

Monitor runtimes and the status of BI processes

Monitor loading and BI processes: Daily

Monitor the performance of BI applications: Weekly

You can execute the following monitoring tasks in the Administration Cockpit:

●      Display the runtime statistics for query views, Web templates, Web items, BEx workbooks and InfoProviders

●      Display the runtime statistics for data load processes (InfoPackages and data transfer processes), process chains, and processes in process chains

●      Display the status of requests in BI objects and of processes and process chains

You can call further analysis functions from the context menu. More information: BI Administration Cockpit.

The data displayed in the Administration Cockpit is based on the technical content for BI statistics. More information: Technical Content in the BI Administration Cockpit.

In Query Designer, you can define threshold values (exceptions) for user-defined or delivered queries for technical content. Using information broadcasting, you can forward a document to system administration when a lower or upper threshold value is exceeded. This enables you to trigger alerts and forward them to the Universal Worklist (UWL).

More information: Exception Reporting

Additional Monitoring Tasks

Check the BI delta queue

Daily

The delta queue is a data store for change records in the source system. In the delta queue for a DataSource, you can check whether and how much data it contains. For DataSources that support generic deltas, you can display the current value of the delta-relevant field in the delta queue.

More information: Checking the Delta Queue  

Monitor data requests and data processing for real-time data acquisition

Daily

The monitor for real-time data acquisition displays requests for InfoPackages and requests for data transfer processes, together with their status. You can navigate to the relevant request monitor to display detailed information.

More information: Monitoring Real-Time Data Acquisition

Display structure and status of aggregates or BI accelerator indexes

Check aggregates and BI accelerator indexes

More information: Status Display and Check Tools

Monitor BI log files

The log files can be found in the Log Viewer in logging category Application/BI under ./log/Application/BI/*.

More information: Monitoring and Displaying Log Files

Display and evaluate BI logs in the application log

You can find BI logs in the application log (transaction SLG1) if you select RS* or BW* as the object.

More information: Application Log – User Guidelines (BC-SRV-BAL)

Housekeeping

Page out or delete business and administration data

Data archiving and near-line storage, depending on your data-ageing strategy

Business data: Weekly. Quarterly for aggregates.

Administrative data: Weekly

Statistical data: Quarterly

To optimize the data volume in your system, we recommend archiving or deleting certain data on a regular basis.

More information: Optimization of Data Retention

Task

Description

Can Be Called Using CCMS

Can Be Called Using Administration Cockpit

Check process chain runs

More information: Process Chain Log Display

Yes

When you double-click the progress of a process chain in the BI monitor in CCMS, the system displays the log view of the process chain maintenance. You use this to check the process chain run.

Yes

On the Process Status or Process Chain Statistics page when you choose the corresponding entry in the context menu of one of the monitors for the process chain run, the system calls the log view for process chain maintenance. You use this to check the process chain run.

Monitor data requests (PSA requests)

PSA requests and their data processing in BI are monitored using the extraction monitor.

More information: Extraction Monitor

Yes

The call can be made using the log for a process chain run.

Yes

The call can be made using the log for a process chain run.

Monitor data transfer processes (DTP requests)

DTP requests and their data processing in BI are monitored using the DTP monitor.

More information: DTP Monitor

Yes

The call can be made using the log for a process chain run.

Yes

On the DTP Statistics page when you choose the corresponding entry in the context menu of one of the monitors for the DTP run, the system calls the DTP monitor. You use this to check the DTP run.

The call can also be made using the log for a process chain run.

Monitor change runs

Using this task, you can monitor hierarchy and attribute change runs for aggregates and BI accelerator indexes.

More information: System Response Upon Changes to Master Data and Hierarchies

Yes

The call can be made using the log for a process chain run.

Yes

The call can be made using the log for a process chain run.

3.x data flow: Monitor open hub requests

When you activate and execute an InfoSpoke, a request is generated. This request is displayed in the open hub monitor where you can check the status.

You can call the open hub monitor in the Administration functional area of the Data Warehousing Workbench under Monitors.

More information: Open Hub Monitor 

No

No

Manage InfoProviders

The administration for InfoProviders allows you to trace the status of a request in an InfoProvider and verify the InfoProvider contents.

You can call administration for an InfoProvider in the object tree in the Data Warehousing Workbench by choosing Manage in the context menu for the InfoProvider.

More information: Administration of InfoProviders, in particular:

Requests in InfoCubes and InfoCube Content

Requests in DataStore Objects and DataStore Object Content

Manage InfoObjects

No

Yes

On the BI Object Request Status, InfoProvider Status, or InfoProvider Statistics page when you choose the corresponding entry in the context menu of one of the monitors for an InfoProvider, the system calls InfoProvider administration. You use this to check the process chain run.

Monitor loading, activation and update status of DataStore objects

More information: DataStore Object Content

No

Yes

The status information for the DataStore object is displayed directly in the Administration Cockpit.

Analyze statistical data for BI

In BI you can record and evaluate statistics using the runtimes in various areas and using the statuses of BI objects. If you use the technical content for statistical data, you can evaluate the data using the workload monitor (ST03) as well as using the BI Administration Cockpit.

More information:

BI Statistics

Workload Monitor

No

Yes