US 11,720,597 B2
Generating an OLAP model from a spreadsheet
Andrew Thomas Nelmes, East Sheen (GB); Jonathan Co, York (GB); and Alexandros Komninos, York (GB)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US); and University of York, York (GB)
Filed on Feb. 21, 2020, as Appl. No. 16/797,024.
Claims priority of application No. 1916804 (GB), filed on Nov. 19, 2019.
Prior Publication US 2021/0149920 A1, May 20, 2021
Int. Cl. G06F 16/28 (2019.01); G06F 40/18 (2020.01); G06N 5/04 (2023.01); G06F 40/30 (2020.01)
CPC G06F 16/283 (2019.01) [G06F 40/18 (2020.01); G06F 40/30 (2020.01); G06N 5/04 (2013.01)] 20 Claims
OG exemplary drawing
 
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).