US 11,886,462 B2
Intelligent transformation of multidimensional data for automatic generation of pivot tables
Alexandre Benoit, Redmond, WA (US)
Assigned to MICROSOFT TECHNOLOGY LICENSING, LLC, Redmond, WA (US)
Filed by Microsoft Technology Licensing, LLC, Redmond, WA (US)
Filed on Dec. 9, 2021, as Appl. No. 17/546,794.
Prior Publication US 2023/0185820 A1, Jun. 15, 2023
Int. Cl. G06F 16/25 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/258 (2019.01) [G06F 16/2282 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
receiving an indication to generate a pivot table from an existing table in a software application or service;
determining a plurality of fields included in the existing table to populate the pivot table with;
arranging, in memory, the plurality of fields in a first order;
arranging an order of the plurality of fields from the first order to a semantic hierarchical order based on a set of cardinality relationship rules;
identifying a plurality of blocks included in the plurality of fields in the semantic hierarchical order;
generating the pivot table with the plurality of fields, wherein the generating comprises:
populating columns in the pivot table from fields included in one or more blocks of the plurality of blocks that have a cardinality value less than a threshold cardinality value, and
populating rows in the pivot table from fields included in one or more blocks of the plurality of blocks that have a cardinality value that meets or exceeds the threshold cardinality value; and
rendering the pivot table in the software application or service.