Intelligent transformation of multidimensional data for automatic generation of pivot tables
AssigneeMicrosoft Technology Licensing, LLC
InventorAlexandre Benoit
Life of this patent
Estimating the term…
Abstract
In non-limiting examples of the present disclosure, systems, methods and devices for generating pivot tables are provided. A pivot table service may receive an indication to generate a pivot table. The pivot table service may transform a plurality of fields in an existing table in a software application from a first order to a semantic hierarchical order by applying a set of cardinality relationship rules to the plurality of fields. The pivot table service may identify a plurality of blocks comprising one or more fields from the semantic hierarchical order. Fields from each block may be populated and positioned in a pivot table that is being generated based on a cardinality value of each block.
Claims20
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.
A system comprising:
- a memory for storing executable program code;
- and
- a processor, functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program code and operative to:
- receive an indication to generate a pivot table from an existing table in a software application or service;
- determine a plurality of fields included in the existing table to populate the pivot table with;
- arrange, in memory, the plurality of fields in a first order;
- arrange an order of the plurality of fields from the first order to a semantic hierarchical order based on a set of cardinality relationship rules;
- identify a plurality of blocks included in the plurality of fields in the semantic hierarchical order;
- generate the pivot table with the plurality of fields, wherein the generating comprises:
- populating columns in the pivot table from fields included in a block of the plurality of blocks that has 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
- render the pivot table in the software application or service.
A computer-readable storage device comprising executable instructions that, when executed by a processor, assist with generating a pivot table, the computer-readable storage device including instructions executable by the processor for:
- receiving an indication to generate the 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 a block of the plurality of blocks that has 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.
Dependencies are inferred from the claim text.