CPC G06F 16/283 (2019.01) [G06F 40/18 (2020.01); G06F 40/30 (2020.01); G06N 5/04 (2013.01)] | 20 Claims |
1. A computer-implemented method for generating an Online Analytical Processing (OLAP) model from a spreadsheet, the method comprising:
identifying one or more tables comprising numerical data of the spreadsheet;
identifying content and structure of OLAP dimensions based on the identified one or more tables;
defining an associated cube for each of the identified one or more tables;
for each cube, transforming data from the table associated with the cube into one or more cube entries of the cube,
for a numerical value of the table, identifying associated leaf dimension members, and generating the one or more cube entries based on the numerical value and the associated leaf dimension members;
transforming formulae of the spreadsheet by replacing cell references in the formulae with dimension members from their corresponding cube entries;
modifying the cube(s) based on the transformed formulae; and
generating one or more OLAP rules based on the transformed formula, OLAP dimensions and the cube(s).
|