DATA VISUALIZATION WITH DERIVED DIMENSIONAL HIERARCHY
Data visualization with derived dimensional hierarchy including presenting, by a table manager via a graphical user interface (GUI) on a client computing system, column identifiers from a table retrieved from a cloud-based data warehouse; receiving, by the table manager, an instruction to generate a first visualization, wherein the instruction to generate the first visualization comprises a selection of column identifiers; deriving, by the table manager, a dimensional hierarchy based on the selected column identifiers; and generating, by the table manager based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system.
1 . A method for data visualization with derived dimensional hierarchy, the method comprising:
presenting, by a table manager via a graphical user interface (GUI) on a client computing system, column identifiers from a table retrieved from a cloud-based data warehouse;
receiving, by the table manager, an instruction to generate a first visualization, wherein the instruction to generate the first visualization comprises a selection of column identifiers;
deriving, by the table manager, a dimensional hierarchy based on the selected column identifiers; and
generating, by the table manager based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system.
2 . The method of claim 1 , further comprising:
receiving an instruction to generate a second visualization using the first visualization, wherein the instruction to generate the second visualization comprises a selection of an element from the first visualization; and
generating, based on the selected element from the first visualization, the second visualization in the GUI of the client computing system.
3 . The method of claim 1 , further comprising:
receiving a table edit from the client computing system; and
manipulating the table based on the table edit.
4 . The method of claim 3 , wherein the selection of column identifiers refers to at least one column targeted by the table edit.
5 . The method of claim 3 , wherein the table edit and the first visualization are stored in a workbook repository on an intermediary computing system.
6 . The method of claim 1 , wherein deriving the dimensional hierarchy based on the selected column identifiers comprises:
determining a relationship between the columns identified by the selected column identifiers; and
generating source data for the first visualization based on the determined relationship between the columns identified by the selected column identifiers.
7 . The method of claim 1 , wherein generating, based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system comprises generating a database statement targeting the cloud-based data warehouse using the derived dimensional hierarchy.
8 . The method of claim 7 , wherein the database statement is a structured query language statement.
9 . The method of claim 1 , wherein the selection of column identifiers comprises an identifier of a calculation column.
10 . The method of claim 1 , wherein the table manager is executing on an intermediary computing system between the client computing system and the cloud-based data warehouse.
11 . An apparatus for data visualization with derived dimensional hierarchy, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
presenting, by a table manager via a graphical user interface (GUI) on a client computing system, column identifiers from a table retrieved from a cloud-based data warehouse;
receiving, by the table manager, an instruction to generate a first visualization, wherein the instruction to generate the first visualization comprises a selection of column identifiers;
deriving, by the table manager, a dimensional hierarchy based on the selected column identifiers; and
generating, by the table manager based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system.
12 . The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving an instruction to generate a second visualization using the first visualization, wherein the instruction to generate the second visualization comprises a selection of an element from the first visualization; and
generating, based on the selected element from the first visualization, the second visualization in the GUI of the client computing system.
13 . The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving a table edit from the client computing system; and
manipulating the table based on the table edit.
14 . The apparatus of claim 13 , wherein the selection of column identifiers refers to at least one column targeted by the table edit.
15 . The apparatus of claim 13 , wherein the table edit and the first visualization are stored in a workbook repository on an intermediary computing system.
16 . The apparatus of claim 11 , wherein deriving the dimensional hierarchy based on the selected column identifiers comprises:
determining a relationship between the columns identified by the selected column identifiers; and
generating source data for the first visualization based on the determined relationship between the columns identified by the selected column identifiers.
17 . The apparatus of claim 11 , wherein generating, based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system comprises generating a database statement targeting the cloud-based data warehouse using the derived dimensional hierarchy.
18 . The apparatus of claim 17 , wherein the database statement is a structured query language statement.
19 . The apparatus of claim 11 , wherein the selection of column identifiers comprises an identifier of a calculation column.
20 . A computer program product for data visualization with derived dimensional hierarchy, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
presenting, by a table manager via a graphical user interface (GUI) on a client computing system, column identifiers from a table retrieved from a cloud-based data warehouse;
receiving, by the table manager, an instruction to generate a first visualization, wherein the instruction to generate the first visualization comprises a selection of column identifiers;
deriving, by the table manager, a dimensional hierarchy based on the selected column identifiers; and
generating, by the table manager based on the derived dimensional hierarchy, the first visualization in the GUI of the client computing system.