Oracle Corporation
System and method for automatic root cause analysis and automatic generation of key metrics in a multidimensional database environment

Abstract:

In accordance with an embodiment, described herein are systems and methods for automatic root cause analysis and generation of key metrics in a multidimensional database. A system can comprise a computer and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. One or more one or more user logs are created, the one or must user logs representing a plurality of operations performed by a plurality of users of the multidimensional database server and accessing the at least one hierarchical structure of data dimensions. Based upon historical data of the at least one hierarchical structure of data dimensions, a change in a query result of a user is detected. Based upon the detection of a change, a set of data dimensions can be provided to the user that contains the data dimensions most contributing to the change.