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 a plurality of 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 fields with the columns shelf and to associate one or more second fields 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 fields, and each pane has a y-axis defined based on data for the one or more second fields.
1. A 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 a plurality of fields from 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 fields with the columns shelf and to associate one or more second fields with the rows shelf; and
generating 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 fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.
2. The method of claim 1 , wherein generating the visual table comprises generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.
3. The method of claim 1 , wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.
4. The method of claim 1 , wherein the schema information region and the data visualization region are displayed as separate windows in the graphical user interface on the display.
5. The method of claim 1 , wherein each of a plurality fields corresponds to a measure or a dimension of the database.
6. The method of claim 1 , further comprising:
retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and
displaying the retrieved tuples as visual marks in the visual table.
7. A computer system for ranking data visualizations, comprising:
a display;
one or more processors;
memory; and
one or more programs stored in the memory for execution by the one or more processors, the one or more programs comprising instructions for:
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 a plurality of fields from 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 fields with the columns shelf and to associate one or more second fields with the rows shelf; and
generating 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 fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.
8. The computer system of claim 7 , wherein the instructions for generating the visual table further comprise instructions for generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.
9. The computer system of claim 7 , wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.
10. The computer system of claim 7 , wherein the instructions for displaying the graphical user interface further comprise instructions for displaying the schema information region and the data visualization region as separate windows on the display.
11. The computer system of claim 7 , wherein each of a plurality of fields corresponds to a measure or a dimension of the database.
12. The computer system of claim 7 , the one or more programs further comprising instructions for:
retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and
displaying the retrieved tuples as visual marks in the visual table.
13. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having a display, one or more processors, and memory storing one or more programs for execution by the one or more processors, the one or more programs comprising instructions for:
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 a plurality of fields from 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 fields with the columns shelf and to associate one or more second fields with the rows shelf; and
generating 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 fields associated with the columns shelf, and each pane has a y-axis defined based on data for the one or more second fields associated with the rows shelf.
14. The computer readable storage medium of claim 13 , wherein the instructions for generating the visual table further comprise instructions for generating within each pane a plurality of visual marks, each corresponding to a respective tuple retrieved from the database.
15. The computer readable storage medium of claim 13 , wherein the data hierarchy is associated with time and comprises a plurality of fields corresponding to different time dimensions.
16. The computer readable storage medium of claim 13 , wherein the instructions for displaying the graphical user interface further comprise instructions for displaying the schema information region and the data visualization region as separate windows on the display.
17. The computer readable storage medium of claim 13 , wherein each of a plurality of fields corresponds to a measure or a dimension of the database.
18. The computer readable storage medium of claim 13 , the one or more programs further comprising instructions for:
retrieving a plurality of tuples from the database according to the fields associated with the rows and columns shelves; and
displaying the retrieved tuples as visual marks in the visual table.