Method and system for providing an interface to a computer system

• US 20060015511A1
• Filed: 01/03/2005
• Published: 01/19/2006
• Est. Priority Date: 07/16/2004
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Sattler, Juergen, Gaffga, Joachim
• Application Number:
  US11/026,050
• Publication Number:
  US 20060015511A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Methods and systems for providing an interface to a data warehouse. In embodiments, data may be extracted from a form that was received at a computer system, and a determination may be made whether each of a plurality of fields in the form data match to data objects in a native data schema used by the computer system. For each field in the form data that does not match a data object in computer system, data received for that field may be stored within a part of a data structure that is assigned to that field of this form, and the data may be used at the computer system to generate a report.

Claims

1. A method comprising:

extracting data from a form that was received at a computer system;

determining whether each of a plurality of fields in the form data match to data objects in a native data schema used by the computer system;

for each field in the form data that does not match a data object in computer system, storing the data received for that field within a part of a data structure that is assigned to that field of this form; and

using the extracted data at the computer system to generate a report.

2. The method of claim 1, wherein form data that does match a data object in computer system is also stored in said data structure.

3. The method of claim 1, wherein the form data is received as an Extensible Mark-up Language message.

4. The method of claim 1, wherein the computer system includes a data warehouse system.

5. A machine-readable medium storing a set of instructions, the set of instructions capable of being executed by a processor to implement a method comprising:

extracting data from a form that was received at a computer system;

determining whether each of a plurality of fields in the form data match to data objects in a native data schema used by the computer system;

for each field in the form data that does not match a data object in computer system, storing the data received for that field within a part of a data structure that is assigned to that field of this form; and

using the extracted data at the computer system to generate a report.

6. The machine-readable medium of claim 5, wherein form data that does match a data object in computer system is also stored in said data structure.

7. The machine-readable medium of claim 5, wherein the form data is received as an Extensible Mark-up Language message.

8. The machine-readable medium of claim 5, wherein the computer system includes a data warehouse system.

9. A method comprising:

generating an electronic form including fields for data entry;

generating a mapping between the fields and data objects of a data schema of a computer system;

storing the mapping at the computer system; and

receiving at the computer system form data that does not match data objects in the native data schema of the computer system.

10. The method of claim 9, wherein the form comprises an Extensible Mark-up Language form.

11. The method of claim 9, further comprising:

extracting data from the form data according to the native data schema of the computer system.

12. The method of claim 11, further comprising:

storing the extracted data on the computer system.

13. A machine-readable medium storing a set of instructions, the set of instructions capable of being executed by a processor to implement a method comprising:

generating an electronic form including fields for data entry;

generating a mapping between the fields and data objects of a data schema of a computer system;

storing the mapping at the computer system; and

receiving at the computer system form data that does not match data objects in the native data schema of the computer system.

14. The machine-readable medium of claim 13, wherein the form comprises an Extensible Mark-up Language form.

15. The machine-readable medium of claim 13, wherein the method further comprises:

extracting data from the form data according to the native data schema of the computer system.

16. The machine-readable medium of claim 13, wherein the method further comprises:

storing the extracted data on the computer system.