International Business Machines Corporation

Andrew Leikucs

Stewart James Winter

Randy Westman

Stephen David Gibson

Murray J Reid

Todd MacCulloch

Mark Randy Westman

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

A method and a system for analyzing a data value of interest in a multidimensional database. The data value of interest is first identified in a structured report. The data source for the structured report is retrieved. A context for the data value of interest in the data source is collected, for example, by extracting a slicer from the structured report, by extracting members of master-detail pages, or by extracting a default measure from the structured report. An analysis specification based on the collected context is then built, and the data value of interest is analyzed using the analysis specification. The result from analyzing the data value of interest may be presented in an analysis view.

System and method for analyzing data in a report

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 segmentation management system manages segmentation of a set of members in a multi-dimensionally modeled data source. The segmentation management system comprises a segment definition manager, a segmentation engine and a segment application manager. The segment definition manager manages definitions of identifiable non-overlapping segments for a given base set of members in a multi-dimensionally modeled data source. The segmentation engine divides the base set of members into the segments based on the definitions of the segments. The segment application manager allows the segments to be used as objects.

Method and system to segment an OLAP set

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

Method and system for removing sparse data in a response to a query to a multidimensional database by establishing a cross-tab with sparse data. After selecting a member in an axis of the cross-tab for sparsity removal, a first set expression on the orthogonal axis is selected in the context of the member. The context of the orthogonal axis is collected for generating a filter set expression with a data removal criteria, based on the collected context; and the query is submitted to the database with the filter set expression.

Growing community of inventors

Ottawa, Canada

Andrew Leikucs