Computer systems and methods for the query and visualization of multidimensional databases

摘要

A computer displays a graphical user interface on its display. The graphical user interface includes a schema information region and a data visualization region. The schema information region includes multiple operand names, each operand corresponding to one or more fields of a multi-dimensional database that includes at least one data hierarchy. The data visualization region includes a columns shelf and a rows shelf. The computer detects user actions to associate one or more first operands with the columns shelf and to associate one or more second operands with the rows shelf. The computer generates a visual table in the data visualization region in accordance with the user actions. The visual table includes one or more panes. Each pane has an x-axis defined based on data for the one or more first operands, and each pane has a y-axis defined based on data for the one or more second operands.

主权项

1. A computer-implemented method, comprising:
at a computer having a display, one or more processors, and memory storing one or more programs for execution by the one or more processors:
displaying a graphical user interface on the display, wherein the graphical user interface includes a schema information region and a data visualization region, wherein the schema information region includes multiple operand names, each operand corresponding to one or more fields of a multi-dimensional database that includes at least one data hierarchy, and wherein the data visualization region includes a columns shelf and a rows shelf;detecting user actions to associate one or more first operands with the columns shelf and to associate one or more second operands with the rows shelf; andgenerating a visual table in the data visualization region in accordance with the user actions, wherein the visual table includes one or more panes, each pane has an x-axis defined based on data for the one or more first operands associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second operands associated with the rows shelf.