Method and system for transferring data from a data warehouse

• US 20050216321A1
• Filed: 08/26/2004
• Published: 09/29/2005
• Est. Priority Date: 03/08/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Veit, Thomas
• Granted Patent: US 7,882,088 B2
• Time in Patent Office: Days
• US Class Current: 705/7
• 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 method for transferring data from a data warehouse, comprising:

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.

2. The method of claim 1, wherein transferring the data transfer worklist from the data warehouse is a background process.

3. The method of claim 1, wherein the data transfer worklist is transferred in a XI asynchronous transfer mode.

4. The method of claim 1, wherein transferring the data transfer worklist includes formatting the data transfer worklist.

5. The method of claim 1, wherein generating the data transfer worklist includes adding enriched data to the data transfer worklist based on the included data.

6. The method of claim 5, wherein adding enriched data includes adding data from one or more external data sources.

7. The method of claim 1, further including generating a tree data structure in the price planning workbench based on the data included in the data transfer worklist.

8. The method of claim 7, wherein the generated tree data structure includes the enriched data.

9. A system for transferring data from a data warehouse, comprising:

a data warehouse configured to store retail data;

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

a data transfer channel directly connecting the data warehouse with the price planning workbench to enable transfer of the retail data from the data warehouse to the price planning workbench.

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 a XI asynchronous data transfer mode.

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

13. The system of claim 12, wherein generating the data transfer worklist includes adding enriched data to the 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 price planning workbench includes a retail data tree structure configured to be populated with the transferred retail data.

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

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.

17. The program product of claim 16, wherein transferring the data transfer worklist from the data warehouse is a background process.

18. The program product of claim 16, wherein the data transfer worklist is transferred in a XI asynchronous transfer mode.

19. The program product of claim 16, wherein transferring the data transfer worklist includes formatting the data transfer worklist.

20. The program product of claim 16, wherein generating the data transfer worklist includes adding enriched data to the data transfer worklist based on the included data.

21. The program product of claim 20, wherein adding enriched data includes adding data from one or more external data sources.

22. The program product of claim 16, further including generating a tree data structure in the price planning workbench based on the data included in the data transfer worklist.

23. The program product of claim 22, wherein the generated tree data structure includes the enriched data.