DYNAMIC DIMENSION BINDING FOR WORKBOOK ELEMENTS
Dynamic dimension binding for workbook elements including presenting, by a workbook manager, a workbook element on a GUI of a client computing system, wherein the workbook element presents a data set from a cloud-based data warehouse; receiving, by the workbook manager via the GUI, a formula that includes a reference to a channel within the workbook element, wherein the channel of the workbook element is bound to a first dimension of the data set; detecting, by the workbook manager, that the formula references the channel within the workbook element; and rewriting by the workbook manager, the formula by replacing the reference to the channel within the workbook element with the first dimension bound to the channel.
1 . A method for dynamic dimension binding for workbook elements, the method comprising:
presenting, by a workbook manager, a workbook element on a GUI of a client computing system, wherein the workbook element presents a data set from a cloud-based data warehouse;
receiving, by the workbook manager via the GUI, a formula that includes a reference to a channel within the workbook element, wherein the channel of the workbook element is bound to a first dimension of the data set;
detecting, by the workbook manager, that the formula references the channel within the workbook element; and
rewriting, by the workbook manager, the formula by replacing the reference to the channel within the workbook element with the first dimension bound to the channel.
2 . The method of claim 1 , further comprising:
presenting, on the GUI of the client computing system, a revised workbook element modified according to the rewritten formula.
3 . The method of claim 1 , further comprising:
detecting that the channel of the workbook element is rebound to a second dimension of the data set; and
rewriting the formula by replacing the reference to the channel within the workbook element with the second dimension bound to the channel.
4 . The method of claim 1 , wherein the first dimension of the data set is a column.
5 . The method of claim 1 , wherein detecting that the formula references the channel within the workbook element comprises detecting that the formula references a parent of the channel.
6 . The method of claim 1 , wherein presenting the workbook element on the GUI of the client computing system comprises issuing a database statement to the cloud-based data warehouse and receiving the data set as query results from the cloud-based data warehouse.
7 . The method of claim 1 , wherein the workbook element is one element within a workbook presented on the GUI of the client computing system
8 . The method of claim 1 , wherein the workbook element is one selected from a group consisting of a spreadsheet structure and a data visualization.
9 . The method of claim 1 , wherein rewriting the formula comprises storing the workbook with the rewritten formula on an intermediary computing system between the client computing system and the cloud-based data warehouse.
10 . The method of claim 1 , wherein the workbook manager is on a workbook manager computing system between the client computing system and the cloud-based data warehouse.
11 . An apparatus for dynamic dimension binding for workbook elements, 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 a workbook element on a GUI of a client computing system, wherein the workbook element presents a data set from a cloud-based data warehouse;
receiving, via the GUI, a formula that includes a reference to a channel within the workbook element, wherein the channel of the workbook element is bound to a first dimension of the data set;
detecting that the formula references the channel within the workbook element; and
rewriting the formula by replacing the reference to the channel within the workbook element with the first dimension bound to the channel.
12 . The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the step of:
presenting, on the GUI of the client computing system, a revised workbook element modified according to the rewritten formula.
13 . The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
detecting that the channel of the workbook element is rebound to a second dimension of the data set; and
rewriting the formula by replacing the reference to the channel within the workbook element with the second dimension bound to the channel.
14 . The apparatus of claim 11 , wherein the first dimension of the data set is a column.
15 . The apparatus of claim 11 , wherein detecting that the formula references the channel within the workbook element comprises detecting that the formula references a parent of the channel.
16 . The apparatus of claim 11 , wherein presenting the workbook element on the GUI of the client computing system comprises issuing a database statement to the cloud-based data warehouse and receiving the data set as query results from the cloud-based data warehouse.
17 . The apparatus of claim 11 , wherein the workbook element is one element within a workbook presented on the GUI of the client computing system
18 . The apparatus of claim 11 , wherein the workbook element is one selected from a group consisting of a spreadsheet structure and a data visualization.
19 . The apparatus of claim 11 , wherein rewriting the formula comprises storing the workbook with the rewritten formula on an intermediary computing system between the client computing system and the cloud-based data warehouse.
20 . A computer program product for dynamic dimension binding for workbook elements, 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 a workbook element on a GUI of a client computing system, wherein the workbook element presents a data set from a cloud-based data warehouse;
receiving, via the GUI, a formula that includes a reference to a channel within the workbook element, wherein the channel of the workbook element is bound to a first dimension of the data set;
detecting that the formula references the channel within the workbook element; and
rewriting the formula by replacing the reference to the channel within the workbook element with the first dimension bound to the channel.