Dimensional data chart matrixes with drill operations

A computer program product comprising:

• one or more computer-readable tangible storage devices;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to output a user interface comprising a row header user interface section, a column header user interface section, and a grid header user interface section, the user interface enabling a user to place selected data dimensions into the row header user interface section, the column header user interface section, and the grid header user interface section;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to associate a first grid data dimension with a first position in the grid header user interface section;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to associate a first row data dimension with a first position in the row header user interface section, wherein the first row data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to associate a first column data dimension with a first position in the column header user interface section, wherein the first column data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to associate a second data dimension with a second position in one of the row header user interface section and the column header user interface section, wherein the second data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to output a chart matrix having column headers, row headers and a plurality of cells arranged in rows and columns, the chart matrix defined by members of the first row data dimension at a selected level of the hierarchy of members of the first row data dimension and by members of the first column data dimension at a selected level of the hierarchy of members of the first column data dimension, wherein labels associated with members of the first row data dimension at the selected level of the hierarchy of members of the first row data dimension are displayed as row headers for each of the rows of the chart matrix, and wherein labels associated with members of the first column data dimension at the selected level of the hierarchy of members of the first column data dimension are displayed as column headers for each of the columns of the chart matrix, wherein the cells of the chart matrix are defined by intersections of rows defined by the members of the first row data dimension at the selected level of the hierarchy of members of the first row data dimension with columns defined by the members of the first column data dimension at the selected level of the hierarchy of members of the first column data dimension;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to output, for each cell in the chart matrix, an initial chart depicting data corresponding to the first grid data dimension for each member of the second data dimension at a selected level of the hierarchy of members of the second data dimension, the initial chart further based on the member of the first row data dimension that defines the row of the cell and on the member of the first column data dimension that defines the column of the cell, wherein outputting the initial chart includes displaying, in each cell in the chart matrix, a first plurality of labels corresponding to members of the second data dimension at the selected level of the hierarchy of members of the second data dimension;
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to perform a drill operation on a selected member of the second data dimension, wherein performing the drill operation includes selecting a label of the first plurality of labels displayed in each cell of the chart matrix that corresponds to the selected member of the second data dimension to provide a context menu, each label in the first plurality of labels corresponding to a respective member of the members of the second data dimension at the selected level of the hierarchy of members of the second data dimension, the context menu displaying an option in the first row data dimension, an option in the first column data dimension, and an option in the second data dimension, wherein performing the drill operation includes selecting the option in the second data dimension;
• and
• program instructions, stored on at least one of the one or more computer-readable tangible storage devices, to output, in response to the drill operation, a modified chart for each cell based on members related to the selected member, wherein the members related to the selected member are one hierarchical level removed from the selected member in the data dimension containing the selected member and wherein outputting the modified chart includes displaying, in each cell in the chart matrix, a second plurality of labels corresponding to the members related to the selected member that are one hierarchical level removed from the selected member in the data dimension containing the selected member.

A computing device, comprising:

• at least one processor;
• and
• at least one memory operably coupled to the at least one processor, wherein the at least one processor is configured to:
• output a user interface comprising a row header user interface section, a column header user interface section, and a grid header user interface section, the user interface enabling a user to place selected data dimensions into the row header user interface section, the column header user interface section, and the grid header user interface section;
• associate a first grid data dimension with a first position in the grid header user interface section;
• associate a first row data dimension with a first position in the row header user interface section, wherein the first row data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members;
• associate a first column data dimension with a first position in the column header user interface section, wherein the first column data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members;
• output a chart matrix having column headers, row headers and a plurality of cells arranged in rows and columns, the chart matrix defined by members of the first row data dimension at a selected level of the hierarchy of members of the first row data dimension and by members of the first column data dimension at a selected level of the hierarchy of members of the first column data dimension, wherein labels associated with members of the first row data dimension at the selected level of the hierarchy of members of the first row data dimension are displayed as row headers for each of the rows of the chart matrix, and wherein labels associated with members of the first column data dimension at the selected level of the hierarchy of members of the first column data dimension are displayed as column headers for each of the columns of the chart matrix, wherein the cells of the chart matrix are defined by intersections of rows defined by the members of the first row data dimension at the selected level of the hierarchy of members of the first row data dimension with columns defined by the members of the first column data dimension at the selected level of the hierarchy of members of the first column data dimension;
• output, within each cell of the chart matrix, an initial chart depicting data corresponding to the first grid data dimension based on the member of the first row data dimension that defines the row of the cell and on the member of the first column data dimension that defines the column of the cell, wherein the initial charts are further based on an additional data dimension placed in an additional position in the row header user interface section or in an additional position in the column header user interface section, wherein the additional data dimension includes a plurality of members arranged in two or more levels in a hierarchy of members, wherein outputting the initial chart includes displaying, in each cell in the chart matrix, a first plurality of labels corresponding to members of the additional data dimension at the selected level of a hierarchy of members of the additional data dimension;
• perform a drill operation on a selected member of the additional data dimension, wherein performing the drill operation includes selecting a label of the first plurality of labels displayed in each cell of the chart matrix that corresponds to the selected member of the additional data dimension to provide a context menu, each label in the first plurality of labels corresponding to a respective member of the members of the additional data dimension at the selected level of the hierarchy of members of the additional data dimension, the context menu displaying an option in the first row data dimension, an option in the first column data dimension, and an option in the additional data dimension, wherein performing the drill operation includes selecting the option in the additional data dimension;
• and
• output, in response the drill operation, a modified chart for each cell, the modified chart based on members related to the selected member, wherein the members related to the selected member are one hierarchical level removed from the selected member in the data dimension containing the selected member and wherein outputting the modified chart includes displaying, in each cell in the chart matrix, a second plurality of labels corresponding to the members related to the selected member that are one hierarchical level removed from the selected member in the data dimension containing the selected member.