International Business Machines Corporation

Anaplan, Inc.

Jonathan Co

Alexandros Komninos

Andrew Thomas Nelmes

Robin Ward Stafford

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.

System and method for converting spreadsheets into data models

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.

Generating an OLAP model from a spreadsheet

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.

Identifying content and structure of OLAP dimensions from a spreadsheet

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.

Identifying data relationships from a spreadsheet

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

Growing community of inventors

York, United Kingdom

Jonathan Co