Abstract: A method for converting a spreadsheet into a data model includes: obtaining the spreadsheet including a plurality of cells containing data; identifying local structures within the spreadsheet using attributes of the data in the spreadsheet; combining the local structures of the spreadsheet into a generic multi-dimensional model comprising dimensions and data cubes; generating the data model using the generic multi-dimensional model by mapping elements of the generic multi-dimensional model to elements of the data model; and displaying, on a display and to a user, the data model. The dimensions and the data cubes are the elements of the generic multi-dimensional model.

Abstract: Proposed are concepts for identifying OLAP dimensions from a spreadsheet. Such a concept may determine contents and structure of an OLAP dimension from a spreadsheet using position, formatting, data and formulae. This may, for example, facilitating creation of an OLAP mode in a manner that would otherwise not be possible with the existing tools.

Abstract: Proposed are concepts for transforming a spreadsheet (or set of spreadsheets) into a knowledge base for analysis. Such a concept may convert a spreadsheet into a structured OLAP model that facilitates detailed analysis. For instance, by turning the semi-structured cell-based data representation into a structured OLAP model, it may be possible to perform analysis that would otherwise not be possible with the existing tools.

Abstract: Proposed are concepts for identifying data relationships from a spreadsheet. Such a concept may transform formulae by replacing the variables in each formula with descriptive labels. This may, for example, expressing the transformed formulae in terms that have more meaning to a user, the facilitating understanding and/or analysis that would otherwise not be possible with the existing tools.

Abstract: Proposed are concepts for identifying data relationships from a spreadsheet. Such a concept may transform formulae by replacing the variables in each formula with descriptive labels. This may, for example, expressing the transformed formulae in terms that have more meaning to a user, the facilitating understanding and/or analysis that would otherwise not be possible with the existing tools.

Abstract: Proposed are concepts for identifying OLAP dimensions from a spreadsheet. Such a concept may determine contents and structure of an OLAP dimension from a spreadsheet using position, formatting, data and formulae. This may, for example, facilitating creation of an OLAP mode in a manner that would otherwise not be possible with the existing tools.

Abstract: Proposed are concepts for transforming a spreadsheet (or set of spreadsheets) into a knowledge base for analysis. Such a concept may convert a spreadsheet into a structured OLAP model that facilitates detailed analysis. For instance, by turning the semi-structured cell-based data representation into a structured OLAP model, it may be possible to perform analysis that would otherwise not be possible with the existing tools.

Abstract: An enterprise planning and performance management system provides a variable-based modeling technique that enables users to interact with a more manageable variable-centric front-end for complex enterprise planning software. The system enables users to specify a plurality of variable definitions via a variable-based user interface. Based on the plurality of variable definitions, the system generates, and in some instances automatically generates, model data that defines an enterprise planning model. The system uses the model data during subsequent enterprise planning sessions. Because model builders typically comprise financial analysts unfamiliar with traditional complex enterprise modeling techniques but familiar with common financial variables of an enterprise, this variable-based modeling technique may facilitate easier model building by allowing these financial analysts to generate model data from the perspective of the more readily understood variables.

Abstract: Techniques are described of entering and presenting data in an enterprise planning and performance management system. As disclosed herein, the techniques facilitate the capture and entry of data into an underlying multidimensional dataset through action-based forms. In addition, the techniques allow reviewers to use spreadsheet-like views of the captured data. In certain embodiments, the techniques also facilitate straightforward review of changes to data within the spreadsheet-like views by providing a task log that enables reviewers to more readily review, accept, or dismiss such changes.