CREATING AND STORING A DATA FIELD ALTERATION DATUM USING AN ANALYTIC PLATFORM
A method for reading the altered data field in accordance with the field alteration data is provided. The method may include altering a data field characteristic of a data field in a data table, saving the field alteration datum associated with the alteration in a data storage facility, submitting a query requiring the use of the data field in the dataset and reading the altered data field in accordance with the field alteration data. The alteration may generate a field alteration datum and a component of the query may consist of reading the field alteration data.
1 . A method comprising:
altering a data field characteristic of a data field in a data table to provide an altered data field including an alteration, wherein the alteration generates a field alteration datum;
saving the field alteration datum associated with the alteration in a data storage facility;
submitting a query requiring a use of the data field in a dataset, wherein a component of the query consists of reading the field alteration datum; and
reading the altered data field in accordance with the field alteration datum.
2 . The method of claim 1 wherein the data table is a fact data table.
3 . The method of claim 1 wherein the fact data table is a retail sales dataset.
4 . The method of claim 1 wherein the fact data table is a syndicated sales dataset.
5 . The method of claim 4 wherein the syndicated sales dataset is a scanner dataset.
6 . The method of claim 4 wherein the syndicated sales dataset is an audit dataset.
7 . The method of claim 4 wherein the syndicated sales dataset is a combined scanner-audit dataset.
8 . The method of claim 1 wherein the fact data table is point-of-sale data.
9 . The method of claim 1 wherein the fact data table is a syndicated causal dataset.
10 . The method of claim 1 wherein the fact data table is an internal shipment dataset.
11 . The method of claim 1 wherein the fact data table is an internal financials dataset.
12 . The method of claim 1 wherein the data table includes dimension data.
13 . The method of claim 12 wherein the dimension is a store.
14 . The method of claim 12 wherein the dimension is a hierarchy.
15 . The method of claim 12 wherein the dimension is a category.
16 . The method of claim 12 wherein the dimension is a data segment.
17 . The method of claim 12 wherein the dimension is a time.
18 . The method of claim 12 wherein the dimension is a venue.
19 . The method of claim 12 wherein the dimension is a geography.
20 . The method of claim 12 wherein the dimension is a demographic.
21 . The method of claim 12 wherein the dimension is a behavior.
22 . The method of claim 12 wherein the dimension is a life stage.
23 . The method of claim 12 wherein the dimension is a consumer segment.