Automatic monitoring and statistical analysis of dynamic process metrics to expose meaningful changes

A computer program product comprising a computer-readable storage medium, the computer-readable storage medium including:

• program code for allowing a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy;
• program code for extracting, for each specified measure and for each specified dimension, a time series from a multidimensional database for the specified measure in the specified dimension and automatically calculating, one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique;
• program code for monitoring newly acquired data including each specified measure in each specified dimension for an out-of-limits condition based on one or more automatically-calculated control limits;
• program code for triggering an alert in response to an out-of-limits condition being detected;
• and
• storing each automatically-calculated control limit.

A system comprising:

• a selection module to allow a user to specify at least one measure to be monitored in at least one dimension of a dimensional hierarchy;
• a control limit calculator to extract, for each specified measure and for each specified dimension, a time series from a multidimensional database for the specified measure in the specified dimension and automatically calculate one or more control limits for the specified measure in the specified dimension based on the extracted time series using a Statistical Process Control (SPC) technique;
• a monitoring module to monitor, for newly acquired data, each specified measure in each specified dimension for an out-of-limits condition based on one or more automatically-calculated control limits;
• an alert module to trigger an alert in response to an out-of-limits condition being detected;
• and
• storing each automatically-calculated control limit.