International Business Machines Corporation

Randy Westman

Stewart James Winter

Murray J Reid

Andrew Leikucs

Todd MacCulloch

Andrew Liekucs

William Todd MacCulloch

A context locking method and system lock context of a set of members in a crosstab for further data exploration and analysis. The context locking system has a context information manager and a locking manager. The context locking method information manager collects context information of the selected member. The context locking method manager locks the context of the selected set based on the context information during further exploration or analysis of the crosstab, while allowing the locked set to reflect data changes in the data source.

System and method for locking context of sets of members in crosstabs

Method and system for determining a driving factor for a data value of interest in a multidimensional database, by collecting a context for the data value of interest in the multidimensional database. The data value of interest has dimensional levels with dimensional members outside the drill path of the data value of interest. The dimensional levels are enumerated in a list. A query using the dimensional members of the dimensional level is executed. A variance is calculated for the set of query results. A driving factor for the data value of interest is determined based on the variance. The driving factor is added to the context of the data value of interest.

System and method for determining driving factor in a data cube

A business intelligence analysis client system is used with a business intelligence analysis sever system having an object model representing one or more data sources. The client system maintains a business intelligence analysis client copy of the object model that is maintained by the server system. The client system obtains from the server system a result of the user request including update information, and updates the client copy of the object model according to the update information. The client system presents the result of the user request based on the updated client copy of the object model.

System and method for delivering business intelligence data in a client/server architecture

A definition manager independently defines a plurality of dimensional members of a data source. An operation manager receives user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator. The set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy. A display manager places the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis.

Comparative analysis of business intelligence data

A large report management system manages a large Online Analytic Processing (OLAP) report. The system segments a set of members of interest for an OLAP report to define one or more segments, and determines an interest degree of each segment. The system generates a summarized representation of each segment that is of lesser interest, and presents a report with members of each segment of greater interest and the summarized representation of each segment of lesser interest.

Growing community of inventors

Ottawa, Canada

Randy Westman