Multi Dimensional Analysis Service Test

The Multi-Dimensional Analysis Service (MDAS) runs on the Adaptive Processing Server, provides access to multi-dimensional Online Analytical Processing (OLAP) data, and converts the raw data into XML, so it can be rendered into Excel, PDF, or SAP BusinessObjects Analysis (formerly Voyager) crosstabs and charts. By monitoring the session load on this service, administrators can assess the load-handling ability of the service and also determine whether/not the server and service attributes need to be fine-tuned to maximize performance. This is exactly what the Multi Dimensional Analysis Service test helps administrators achieve. This test tracks the MDAS sessions to the service and reports the number of OLAP data requests received through those sessions that are yet to be processed by the service. In the process, the test reveals how well the service is handling the requests it receives and quickly leads administrators to processing bottlenecks that the service may be experiencing.

Target of the test : A SAP BOBI Node

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the Multi-Dimensional Analysis Service running in the node monitored.

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed.
Host	Host name of the server for which the test is to be configured.
Port	Enter the port to which the specified host listens. This should be the port at which the web application server hosting SAP BOBI listens.
JMX Remote Port	Specify the RMI port number of the BOBI monitoring application.To know the RMI port number of the monitoring application, refer to Enabling the Monitoring Application of the SAP BOBI Platform.
JNDI Name	Specify the lookup name for connecting to the JMX connector of the BOBI monitoring application. To know the JNDI name, refer to Enabling the Monitoring Application of the SAP BOBI Platform.
JMX User and JMX Password	Enter the credentials of an enterprise authenticated BOBI user belonging to the default monitoring users group.
Confirm Password	Confirm the password by retyping it here.
Node Name	Specify the name of the BOBI node being monitored.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Sessions	Indicates the number of connections from MDAS clients to the server.	Number	This is a good indicator of the current session load on the service.
Cube count	Indicates the number of data sources that are being used to supply data to the connections that have not timed out.	Number
Query count	Indicates the number of data requests that are open between the MDS clients and the server.	Number	Ideally, the value of this measure should be low. A consistent rise in this value could indicate that the service is not processing data requests as quickly as they are received. This could be owing to a processing bottleneck on the APS hosting the service, and hence requires further investigation.