Method and system for pivoting a multidimensional dataset

A client device for visualizing a multidimensional dataset characterized by discrete sets of dimension attributes and metric attributes and managed by the server system, the client device connected to a server system through a network and comprising:

• one or more processors for executing programs;
• and
• memory to store data and to store one or more programs to be executed by the one or more processors, the one or more programs including instructions for:
• displaying a first view of a subset of the multi-dimensional dataset, the first view comprising dimension data including a plurality of reference dimension items which vary along a dimension defined by a first reference dimension attribute selected from the set of dimension attributes, and metric data including a measurement of first and second metric attributes selected from the set of metric attributes with respect to each reference dimension item, wherein the dimension data and the metric data are displayed along a first axis;
• receiving, at a user interface presented via the client device, a user request to partition the metric data of the first metric attribute by a first pivot dimension attribute selected from the set of dimension attributes, and to display the metric data of the first metric attribute partitioned along a second axis that is different from the first axis;
• in response to the user request, requesting and receiving from the server system first pivot dimension data including a plurality of pivot dimension items which vary along a dimension defined by the first pivot dimension attribute, and corresponding partitioned metric data of the first metric attribute including a sub-measurement of the first metric attribute with respect to each combination of a reference dimension item and a pivot dimension item;
• displaying a second view of the subset of the multi-dimensional dataset, the second view comprising the first pivot dimension data and the corresponding partitioned metric data of the first metric attribute displayed along the second axis, the partitioned metric data of the first metric attribute at least partially replacing the metric data of the second metric attribute in the second view;
• receiving, at the user interface, a user request to add a second pivot dimension attribute that is different from the first pivot dimension attribute;
• in response to the user request, requesting and receiving from the server system second pivot dimension data and corresponding metric data of the first metric attribute that is partitioned by the first pivot dimension attribute and by the second pivot dimension attribute;
• and
• displaying a third view of the subset of the multi-dimensional dataset, the third view comprising the first pivot dimension data, the second pivot dimension data, and the corresponding partitioned metric data of the first metric attribute displayed along the second axis.

A non-transitory computer readable-storage medium storing one or more programs for execution by one or more processors of a client device for visualizing a multi-dimensional dataset characterized by discrete sets of dimension attributes metric attributes and managed by a server system connected to the client device through a network, the one or more programs comprising instructions for:

• displaying a first view of a subset of the multi-dimensional dataset, the first view comprising dimension data including a plurality of reference dimension items which vary along a dimension defined by a first reference dimension attribute selected from the set of dimension attributes, and metric data including a measurement of first and second metric attributes selected from the set of metric attributes with respect to each reference dimension item, wherein the dimension data and the metric data are displayed along a first axis;
• are discrete sets;
• receiving, at a user interface presented via the client device, a user request to partition the metric data of the first metric attribute by a first pivot dimension attribute selected from the set of dimension attributes, and to display the metric data of the first metric attribute partitioned along a second axis that is different from the first axis;
• in response to the user request, requesting and receiving from the server system first pivot dimension data including a plurality of pivot dimension items which vary along a dimension defined by the first pivot dimension attribute, and corresponding partitioned metric data of the first metric attribute including a sub-measurement of the first metric attribute with respect to each combination of a reference dimension item and a pivot dimension item;
• displaying a second view of the subset of the multi-dimensional dataset, the second view comprising the first pivot dimension data and the corresponding partitioned metric data of the first metric attribute displayed along the second axis, the partitioned metric data of the first metric attribute at least partially replacing the metric data of the second metric attribute in the second view;
• receiving, at the user interface, a user request to add a second pivot dimension attribute that is different from the first pivot dimension attribute;
• in response to the user request, requesting and receiving from the server system second pivot dimension data and corresponding metric data of the first metric attribute that is partitioned by the first pivot dimension attribute and by the second pivot dimension attribute;
• and
• displaying a third view of the subset of the multi-dimensional dataset, the third view comprising the first pivot dimension data, the second pivot dimension data, and the corresponding partitioned metric data of the first metric attribute displayed along the second axis.

A computer-implemented method for visualizing a multi-dimensional dataset having discrete sets of dimension attributes and metric attributes, the method comprising, at a client device having one or more processors and memory storing programs executed by the one or more processors:

• displaying a first view of a subset of the multi-dimensional dataset to a user in accordance with a predefined data visualization scheme, wherein the data visualization scheme includes one or more predefined dimension attributes selected from the set of dimension attributes and one or more predefined metric attributes selected from the set of metric attributes,
• wherein the data visualization scheme includes displaying along a first axis a plurality of reference dimension items which vary along a dimension defined by a first dimension attribute of the one or more predefined dimension attributes, and a measurements of first and second metric attributes of the one or more predefined metric attributes with respect to each reference dimension item;
• receiving, at a user interface presented via the client device, a user selection of one of the set of dimension attributes, wherein the user-selected dimension attribute is not one of the one or more predefined dimension attributes;
• updating the predefined data visualization scheme to include the user-selected dimension attribute in addition to the one or more predefined dimension attributes;
• and
• replacing the first view with a second view of the subset of the multi-dimensional dataset in accordance with the updated data visualization scheme,
• wherein the updated visualization scheme includes a plurality of pivot dimension items which vary along a dimension defined by the user-selected dimension attribute and a sub-measurement of the first metric attribute with respect to each combination of a reference dimension item and a pivot dimension item, the plurality of sub-measurements at least partially replacing the metric data of the second metric attribute in the second view;
• receiving, at the user interface, a user request to add a second pivot dimension attribute that is different from the first pivot dimension attribute;
• in response to the user request, requesting and receiving from the server system second pivot dimension data and corresponding metric data of the first metric attribute that is partitioned by the first pivot dimension attribute and by the second pivot dimension attribute;
• and
• displaying a third view of the subset of the multi-dimensional dataset, the third view comprising the first pivot dimension data, the second pivot dimension data, and the corresponding partitioned metric data of the first metric attribute displayed along the second axis.