GENERATING PERIOD-OVER-PERIOD CALCULATIONS USING A CLOUD-BASED DATA WAREHOUSE
Generating period-over-period calculations using a cloud-based data warehouse including receiving, from a client computing system, a request to add a comparison value column to a table, wherein the request comprises an identifier of a date column, an identifier of a base value column, and an identifier of a prior period; matching a first set of dates in the date column to a second set of dates in the date column using the identifier of the prior period; generating a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column; retrieving the comparison value column from a cloud-based data warehouse using the database statement; and presenting, on the client computing system, the table comprising the comparison value column.
1 . A method for generating period-over-period calculations using a cloud-based data warehouse, the method comprising:
receiving, by a workbook manager from a client computing system via a graphical user interface, a selection of to a date column and a prior period to create a comparison value column for a table;
matching, by the workbook manager, a first set of dates in the date column to a second set of dates in the date column using an identifier of the prior period;
generating, by the workbook manager, a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column;
retrieving, by the workbook manager, the comparison value column from a cloud-based data warehouse using the database statement; and
presenting, by the workbook manager on the client computing system, the table comprising the comparison value column.
2 . The method of claim 1 , wherein the selection further comprises a base value column and wherein creating the comparison value column further comprises joining the comparison value column to the base value column in the table.
3 . The method of claim 1 , wherein matching the first set of dates in the date column to the second set of dates in the date column using the identifier of the prior period comprises determining a time period for rows in the date column.
4 . The method of claim 1 , wherein organizing the comparison value column using values corresponding to the second set of dates in the date column comprises aggregating values in the comparison value column based on a time period for rows in the date column.
5 . The method of claim 1 , wherein the generated database statement further creates a percent change column indicating a difference between entries in a base value column and entries in the comparison value column.
6 . The method of claim 1 , wherein the selection comprises an instruction to truncate dates in the date column.
7 . The method of claim 1 , wherein the table comprises null entries.
8 . The method of claim 1 , wherein retrieving the comparison value column from the cloud-based data warehouse using the database statement comprises:
issuing the database statement to the cloud-based data warehouse; and
receiving query results comprising the comparison value column from the cloud-based data warehouse.
9 . The method of claim 1 , wherein the database statement is a structured query language statement.
10 . The method of claim 1 , wherein the workbook manager is on an intermediary computing system between the client computing system and the cloud-based data warehouse.
11 . An apparatus for generating period-over-period calculations using a cloud-based data warehouse, 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:
receiving, from a client computing system via a graphical user interface, a selection of to a date column and a prior period to create a comparison value column for a table:
matching a first set of dates in the date column to a second set of dates in the date column using the identifier of the prior period;
generating a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column;
retrieving the comparison value column from a cloud-based data warehouse using the database statement; and
presenting, on the client computing system, the table comprising the comparison value column.
12 . The apparatus of claim 11 , wherein the selection further comprises a base value column and wherein creating the comparison value column further comprises joining the comparison value column to the base value column in the table.
13 . The apparatus of claim 11 , wherein matching the first set of dates in the date column to the second set of dates in the date column using the identifier of the prior period comprises determining a time period for rows in the date column.
14 . The apparatus of claim 11 , wherein organizing the comparison value column using values corresponding to the second set of dates in the date column comprises aggregating values in the comparison value column based on a time period for rows in the date column.
15 . The apparatus of claim 11 , wherein the generated database statement further creates a percent change column indicating a difference between entries in a base value column and entries in the comparison value column.
16 . The apparatus of claim 11 , wherein the selection comprises an instruction to truncate dates in the date column.
17 . The apparatus of claim 11 , wherein the table comprises null entries.
18 . The apparatus of claim 11 , wherein retrieving the comparison value column from the cloud-based data warehouse using the database statement comprises:
issuing the database statement to the cloud-based data warehouse; and
receiving query results comprising the comparison value column from the cloud-based data warehouse.
19 . The apparatus of claim 11 , wherein the database statement is a structured query language statement.
20 . A computer program product for generating period-over-period calculations using a cloud-based data warehouse, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, from a client computing system via a graphical user interface, a selection of to a date column and a prior period to create a comparison value column for a table;
matching a first set of dates in the date column to a second set of dates in the date column using the identifier of the prior period;
generating a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column;
retrieving the comparison value column from a cloud-based data warehouse using the database statement; and
presenting, on the client computing system, the table comprising the comparison value column.