Peeking into the Z-dimensional drawer

1. A non-transitory computer readable medium comprising computer readable instructions, which, when executed by a computer, cause the computer to perform a method, comprising:

displaying only a two-dimensional view of values across two measures;

receiving a selection of a slice axis dimension as a third dimension to the only two-dimensional view;

receiving a selection of at least one cell from the only two-dimensional view to show distribution of a value of the at least one cell over the third dimension;

upon activating a handle attached to the at least one cell from the only two-dimensional view, executing a query retrieving third dimensional values along the distribution of the value of the at least one cell over the third dimension; and

displaying a visual representation of the third dimensional values along the distribution of the value of the at least one cell, the visual representation displayed floating above and in addition to the only two-dimensional view, the visual representation displaying the distribution of values changeably presented as a selection of one of: a chart, tags, a map, and a table.

2. The computer readable medium of claim 1 , wherein the handle is exposed by receiving an input device event.

3. The computer readable medium of claim 1 , wherein the handle is exposed by receiving a command from a menu item.

4. The computer readable medium of claim 1 , wherein retrieving the third dimensional values along the distribution of the value of the at least one cell further comprises executing queries in parts, to avoid full query cost, the queries returning a set of the third dimensional values along the distribution of the value of the selected at least one cell over a part of third dimension members.

5. The computer readable medium of claim 4 , wherein the returned set of the third dimensional values along the distribution of the cell value over the part of the third dimension members starts at lowest or highest level of a selected hierarchy.

6. The computer readable medium of claim 4 , wherein the queries are executed until desired data is retrieved.

7. A computerized method for analyzing multidimensional data, comprising:

displaying only a two-dimensional view of values across two measures;

receiving a selection of a tuple from the only two-dimensional view, wherein the tuple is associated with a first member of a first dimension and a second member of a second dimension;

receiving a selection of a third dimension to the only two-dimensional view;

upon activating a handle attached to a cell associated with the tuple, executing a query retrieving third dimensional values along a data distribution associated with the first member, the second member and the third dimension, wherein the third dimensional values along the data distribution present data filtered for the first member and the second member, and grouped by the members in the third dimension; and

generating and displaying a visualization of the third dimensional values along the data distribution associated with the first member, the second member, and the third dimension, wherein the visualization is displayed floating above and in addition to the only two-dimensional view formed by the first dimension and the second dimension, the visualization displaying the distribution of values changeably presented as a selection of one of: a chart, tags, a map, and a table.

8. The method of claim 7 , wherein the handle is exposed by receiving an input device event, or receiving a command from a menu item.

9. The method of claim 7 , wherein retrieving the third dimensional values along the data distribution further comprises:

associating the first member and second member with a row axis of a multi-dimensional query; and

associating the third dimension with a column axis of the multi-dimensional query.

10. The method of claim 7 , wherein retrieving the third dimensional values along the data distribution associated with the first member, the second member and the third dimension further comprises executing queries in parts, wherein the queries are formed from parts of third dimension members.

11. The method of claim 10 , wherein the queries are executed until desired data is retrieved.

12. The method of claim 7 , wherein the visualization is selected based on meta-data associated with the data distribution, wherein the metadata comprises at least one of the group consisting of measure information, dimensions information, and a number of data points in the data distribution.

13. The method of claim 7 , wherein the tuple is associated with a cell included in a plurality of cells.

14. The method of claim 13 , wherein the plurality of cells is a vector or an array.

15. The method of claim 13 , wherein the visualization is selected based on shape of the plurality of cells.

16. A computer system for analyzing multidimensional data, comprising:

a memory, the memory having stored thereon executable instructions related to:

an analysis module operable to, in response to activating a handle attached to at least one cell from only a two-dimensional view of values across two measures, execute a query to retrieve third dimensional values along a distribution of a value of the at least one cell over a third dimension; and

a display module to display a visual representation of the third dimensional values along the distribution of the value of the at least one cell, the visual representation displayed floating above and in addition to the only two-dimensional view, the visual representation displaying the distribution of values changeably presented as a selection of one of: a chart, tags, a map, and a table; and

a processor operable to execute the instructions in the memory related to the analysis module and the display module.

17. The system of claim 16 , wherein the analysis module is further operable to retrieve a set of the third dimensional values along the distribution of the value of the at least one cell over the third dimension in parts.

18. The system of claim 16 , wherein the display module is operable to display the third dimensional values along the distribution of the value in an expanded form occupying an ideal layout next to the display of the only two-dimensional view.

19. A non-transitory computer readable medium comprising computer readable instructions, which, when executed by a computer, cause the computer to perform a method, comprising:

displaying only a two-dimensional view of values across two measures;

receiving a selection of a slice axis dimension as a third dimension to the only two-dimensional view;

receiving a selection of at least one cell from the only two-dimensional view to show distribution of a value of the at least one cell over the third dimension;

upon activating a handle attached to the at least one cell, executing a query retrieving third dimensional values along the distribution of the value of the at least one cell over the third dimension; and

displaying a visual representation of the third dimensional values along the distribution of the value of the at least one cell, the visual representation displayed floating above and in addition to the only two-dimensional view, and wherein the visual representation is a geographical map indicating the distribution of values by graph reflective of their geographical location on the geographical map.