Cross-category view of a dataset using an analytic platform
First Claim
1. A method for facilitating high-speed user exploration of a dimension of projected sales information using actual sales data and projection data in a data warehouse, the method comprising:
- receiving a data set in an analytic platform, the data set including sales data and projection weights applied to the sales data to calculate projections of future sales data;
creating a flexible dimension for a query of aggregated data by, prior to receiving the query, pre-aggregating the sales data and projection weights along a primary sorting dimension into a projected fact table containing projected sales resulting from aggregating the sales data and the projection weights, the projected sales grouped by one or more of time, item, and venue and stored keyed by one or more corresponding keys of time, item, and venue, where an aggregating query in the flexible dimension is used as a lookup in the projected fact table for any values of the flexible dimension used for the pre-aggregating and represented in an index containing references to corresponding facts in the projected fact table;
sorting projected facts in the projected fact table by the primary sorting dimension; and
processing the query against the sales data with respect to the primary sorting dimension using pre-aggregated data in the projected fact table when the query does not seek to vary the primary sorting dimension for the projected fact table and executing a new query against the sales data when the query seeks to vary the primary sorting dimension for the fact table to establish flexibility with respect to at least one dimension for performing computations when the query seeks to vary the primary sorting dimension, wherein when the query does not seek to vary the primary sorting dimension and requires a number of facts in the pre-aggregated data, processing the query includes locating the number of facts and summing a corresponding number of values for the number of facts to provide an analytic result to the query.
16 Assignments
0 Petitions
Accused Products
Abstract
In embodiments, systems and methods may involve using a platform as disclosed herein for applications described herein where the systems and methods involve receiving a dataset in an analytic platform, the dataset including fact data and dimension data for a plurality of distinct product categories. It may also involve storing the data in a flexible hierarchy, the hierarchy allowing the temporary fixing of data along a dimension and flexible querying along other dimensions of the data. It may also involve pre-aggregating certain combinations of data to facilitate rapid querying, the pre-aggregation based on the nature of common queries. It may also involve facilitating the presentation of a cross-category view of an analytic query of the dataset. In embodiments, the temporarily fixed dimension can be rendered flexible upon an action by the user.
187 Citations
20 Claims
-
1. A method for facilitating high-speed user exploration of a dimension of projected sales information using actual sales data and projection data in a data warehouse, the method comprising:
-
receiving a data set in an analytic platform, the data set including sales data and projection weights applied to the sales data to calculate projections of future sales data; creating a flexible dimension for a query of aggregated data by, prior to receiving the query, pre-aggregating the sales data and projection weights along a primary sorting dimension into a projected fact table containing projected sales resulting from aggregating the sales data and the projection weights, the projected sales grouped by one or more of time, item, and venue and stored keyed by one or more corresponding keys of time, item, and venue, where an aggregating query in the flexible dimension is used as a lookup in the projected fact table for any values of the flexible dimension used for the pre-aggregating and represented in an index containing references to corresponding facts in the projected fact table; sorting projected facts in the projected fact table by the primary sorting dimension; and processing the query against the sales data with respect to the primary sorting dimension using pre-aggregated data in the projected fact table when the query does not seek to vary the primary sorting dimension for the projected fact table and executing a new query against the sales data when the query seeks to vary the primary sorting dimension for the fact table to establish flexibility with respect to at least one dimension for performing computations when the query seeks to vary the primary sorting dimension, wherein when the query does not seek to vary the primary sorting dimension and requires a number of facts in the pre-aggregated data, processing the query includes locating the number of facts and summing a corresponding number of values for the number of facts to provide an analytic result to the query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. A computer program product for facilitating high-speed user exploration of a dimension of projected sales information using actual sales data and projection data in a data warehouse, the computer program product comprising computer executable code embodied in a non-transitory computer readable medium that, when executing on one or more computing devices, performs the steps of:
-
receiving a data set in an analytic platform, the data set including sales data and projection weights applied to the sales data to calculate projections of future sales data; creating a flexible dimension for a query of aggregated data by, prior to receiving the query, pre-aggregating the sales data and projection weights along a primary sorting dimension into a projected fact table containing projected sales resulting from aggregating the sales data and the projection weights, the projected sales grouped by one or more of time, item, and venue and stored keyed by one or more corresponding keys of time, item, and venue, where an aggregating query in the flexible dimension is used as a lookup in the projected fact table for any values of the flexible dimension used for the pre-aggregating and represented in an index containing references to corresponding facts in the projected fact table; sorting projected facts in the projected fact table by the primary sorting dimension; and processing the query against the sales data with respect to the primary sorting dimension using pre-aggregated data in the projected fact table when the query does not seek to vary the primary sorting dimension for the projected fact table and executing a new query against the sales data when the query seeks to vary the primary sorting dimension for the fact table to establish flexibility with respect to at least one dimension for performing computations when the query seeks to vary the primary sorting dimension, wherein when the query does not seek to vary the primary sorting dimension and requires a number of facts in the pre-aggregated data, processing the query includes locating the number of facts and summing a corresponding number of values for the number of facts to provide an analytic result to the query. - View Dependent Claims (13, 14, 15, 16, 17, 18, 19, 20)
-
Specification