Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: A context locking system locks 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 information manager collects context information of the selected member. The locking 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.

Abstract: 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.

Abstract: 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.

Abstract: A comparative analysis system allows independent management of definition of dimensional members of a multi-dimensional model. A user can select dimensional members of interest and at least one operator to manipulate the selected members based on the selected operator. The system manages placement of the selected members in a report so that the selected members are displayed adjacently based on the operator to facilitate comparative analysis.

Abstract: A method and system for the integrated installation of software. The method includes the steps of discovering program descriptors of computer programs available to be installed and creating a software environment specification having one or more software environment objects, the specification based on the discovered program descriptors. The method further includes the steps of transferring required files from distribution storage onto a computer system for preparation of the software environment and writing parameter values to parameter storage based on the created software environment specification to adapt the installed software to form a software environment. In an embodiment of the present invention, the method further includes the step of evaluating validity conditions for the software environment objects to validate elements of the software environment.