CPC G06F 16/283 (2019.01) [G06F 16/221 (2019.01); G06F 16/282 (2019.01); G06F 16/285 (2019.01); G06F 40/18 (2020.01); G06F 40/30 (2020.01)] | 18 Claims |
1. A computer-implemented method for identifying content and structure of OLAP dimensions from a spreadsheet, the method comprising:
identifying one or more tables within a spreadsheet, the tables comprising numerical data within the spreadsheet in tabular form, wherein the tables are a column-based type or a crosstab type;
determining labels from the identified one or more tables within the spreadsheet, the labels determined from the identified one or more tables using natural language processing, the labels uniquely identifying the numerical data within the one or more tables; and
determining a set of OLAP dimensions for the spreadsheet based on the one or more tables and the determined labels within the spreadsheet.
|