Method and system for transferring data from a data warehouse

• US 7,882,088 B2
• Filed: 08/26/2004
• Issued: 02/01/2011
• Est. Priority Date: 03/08/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Veit, Thomas
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): Hoang; Son T
• Application Number:
  US10/927,645
• Publication Number:
  US 20050216321A1
• Time in Patent Office: 2,350 Days
• Field of Search: 707/703, 707/826
• US Class Current: 707/703
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

A method for transferring data from a data warehouse. The method includes selecting data from a data warehouse, generating a data transfer worklist including the data, and transferring the data transfer worklist from the data warehouse to a price planning workbench.

Claims

1. A computer-readable storage media for transferring data from a data warehouse, comprising machine-readable program code for causing one or more machines to perform the following method steps:

selecting data from a data warehouse;

generating a data transfer worklist including the data;

comparing the data transfer worklist to a rough worklist;

generating a checked data transfer worklist based on a comparison of the data transfer worklist to the rough worklist;

reporting inconsistent data based on the comparison of the data transfer worklist to the rough worklist;

transferring the checked data transfer worklist from the data warehouse to a price planning workbench, the checked data transfer worklist comprising a first activation level and a second activation level related to a first product and a third activation level and a fourth activation level related to a second product, the first activation level being valid for a first period, the second activation level being valid for a second period, the third activation level being valid for a third period, and the fourth activation level being valid for a fourth period;

determining a first current stock level for the first product;

comparing the first current stock level to the first activation level;

comparing a current date to the first period;

generating a first product promotion based on the first current stock level exceeding the first activation level and at least one day in the first period exceeding or being equal to the current date;

determining a second current stock level for the second product;

comparing the second current stock level to the third activation level;

comparing the current date to the third period;

generating a second product promotion based on the second current stock level exceeding the third activation level and at least one day in the third period exceeding or being equal to the current date;

extending the validity of the first product promotion based on a comparison of a first product predicted sales to a first product actual sales; and

storing in the data warehouse data related to at least one of a first product lifecycle and a second product lifecycle.

2. The computer-readable storage media of claim 1, wherein transferring the checked data transfer worklist from the data warehouse is a background process.

3. The computer-readable storage media of claim 1, wherein the checked data transfer worklist is transferred in an asynchronous transfer mode.

4. The computer-readable storage media of claim 1, wherein transferring the checked data transfer worklist includes formatting the checked data transfer worklist.

5. The computer-readable storage media of claim 1, wherein generating the checked data transfer worklist includes adding enriched data to the checked data transfer worklist based on the included data.

6. The computer-readable storage media of claim 5, wherein adding enriched data includes adding data from one or more external data sources.

7. The computer-readable storage media of claim 1, further including generating a tree data structure in the price planning workbench based on the data included in the checked data transfer worklist.

8. The computer-readable storage media of claim 7, wherein the generated tree data structure includes the enriched data.

9. A machine-readable program code system for transferring data from a data warehouse, comprising:

a data warehouse configured to store retail data;

a hardware price planning workbench processor configured to generate a price planning schedule based on price planning input, a checked retail data, and a price planning budget associated with the price planning input;

a data transfer channel connecting the data warehouse with the price planning workbench processor to enable transfer of the checked retail data from the data warehouse to the price planning workbench processor, the data transfer channel configured to compare a data transfer worklist to a rough worklist, the data transfer channel further configured to report inconsistent data based on a comparison of the data transfer worklist to the rough worklist, the data transfer channel configured to generate the checked retail data based on the comparison, the price planning schedule comprising a first activation level and a second activation level related to a first product and a third activation level and a fourth activation level related to a second product, the first activation level being valid for a first period, the second activation level being valid for a second period, the third activation level being valid for a third period, and the fourth activation level being valid for a fourth period;

the hardware price planning workbench processor being configured to determine a first current stock level for the first product;

the hardware price planning workbench processor being configured to compare the first current stock level to the first activation level;

the hardware price planning workbench processor being configured to compare a current date to the first period;

the hardware price planning workbench processor being configured to generate a first product promotion based on the first current stock level exceeding the first activation level and at least one day in the first period exceeding or being equal to the current date;

the hardware price planning workbench processor being configured to determine a second current stock level for the second product;

the hardware price planning workbench processor being configured to compare the second current stock level to the third activation level;

the hardware price planning workbench processor being configured to compare the current date to the third period;

the hardware price planning workbench processor being configured to generate a second product promotion based on the second current stock level exceeding the third activation level and at least one day in the third period exceeding or being equal to the current date;

the hardware price planning workbench processor being configured to extend the validity of the first product promotion based on a comparison of a first product predicted sales to a first product actual sales; and

the data warehouse being configured to store data related to at least one of a first product lifecycle and a second product lifecycle.

10. The system of claim 9, wherein the data transfer channel is configured to implement data transfers in a background process.

11. The system of claim 9, wherein the data transfer channel is configured to implement an asynchronous data transfer mode.

12. The system of claim 9, wherein the data warehouse is further configured to generate the checked data transfer worklist including the retail data.

13. The system of claim 12, wherein generating the checked data transfer worklist includes adding enriched data to the checked data transfer worklist based on the included retail data.

14. The system of claim 13, wherein the enriched data includes data collected from and external source based on the retail data.

15. The system of claim 9, wherein the hardware price planning workbench includes a retail data tree structure configured to be populated with the transferred retail data.

16. A computer-readable storage medium for transferring data from a data warehouse to a price planning workbench, comprising machine-readable program code for causing one or more machines to perform the following method steps:

selecting data from a data warehouse;

generating a data transfer worklist including the data;

comparing the data transfer worklist to a rough worklist;

generating a checked data transfer worklist based on a comparison of the data transfer worklist to the rough worklist;

reporting inconsistent data based on the comparison of the data transfer worklist to the rough worklist;

transferring the checked data transfer worklist from the data warehouse to a price planning workbench, the checked data transfer worklist comprising a first activation level and a second activation level related to a first product and a third activation level and a fourth activation level related to a second product, the first activation level being valid for a first period, the second activation level being valid for a second period, the third activation level being valid for a third period, and the fourth activation level being valid for a fourth period;

determining a first current stock level for the first product;

comparing the first current stock level to the first activation level;

comparing a current date to the first period;

generating a first product promotion based on the first current stock level exceeding the first activation level and at least one day in the first period exceeding or being equal to the current date;

determining a second current stock level for the second product;

comparing the second current stock level to the third activation level;

comparing the current date to the third period;

generating a second product promotion based on the second current stock level exceeding the third activation level and at least one day in the third period exceeding or being equal to the current date;

determining a third current stock level for the first product;

comparing the third current stock level to the second activation level;

comparing the current date to the second period;

generating the first product promotion based on the third current stock level exceeding the second activation level and at least one day in the second exceeding or being equal to the current date;

determining a fourth current stock level for the second product;

comparing the fourth current stock level to the fourth activation level;

comparing the current date to the fourth period;

generating the second product promotion based on the fourth current stock level exceeding the fourth activation level and at least one day in the fourth period exceeding or being equal to the current date;

extending the validity of the first product promotion based on a comparison of a first product predicted sales to a first product actual sales; and

storing in the data warehouse data related to at least one of a first product lifecycle and a second product lifecycle.

17. The computer-readable storage medium of claim 16, wherein transferring the checked data transfer worklist from the data warehouse is a background process.

18. The computer-readable storage medium of claim 16, wherein the checked data transfer worklist is transferred in an asynchronous transfer mode.

19. The computer-readable storage medium of claim 16, wherein transferring the checked data transfer worklist includes formatting the checked data transfer worklist.

20. The computer-readable storage medium of claim 16, wherein generating the checked data transfer worklist includes adding enriched data to the checked data transfer worklist based on the included data.

21. The computer-readable storage medium of claim 20, wherein adding enriched data includes adding data from one or more external data sources.

22. The computer-readable storage medium of claim 16, further including generating a tree data structure in the price planning workbench based on the data included in the checked data transfer worklist.

23. The computer-readable storage medium of claim 22, wherein the generated tree data structure includes the enriched data.