TRANSFORMING DATA TABLES INTO MULTI-DIMENSIONAL PROJECTIONS WITH AGGREGATIONS

摘要

A data table transformer includes a data receiving module configured to receive a set of rows, each row with a set of attributes, as input data. The data receiving module is also configured to receive locations for at least some of the attributes as zero-based edges. Layers of the edge are presented from the slowest to the fastest varying layers. The data receiving module is further configured to receive a designation of data values that appear at intersections of edge attributes from the same row. The data table transformer is also configured to walk input data by row and for each edge attribute, to distribute the value of the edge attribute to an edge tree created for each zero-based edge location. The data table transformer is further configured to display the data with a multi-dimensional, crosstabular display.