General business report generation

• US 7,076,492 B2
• Filed: 06/29/2001
• Issued: 07/11/2006
• Est. Priority Date: 06/29/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Reynolds, Scotty J., Nugent, James W., Campbell, Michelle D., Willets, Jeffrey G., Parmeter, Debra A.
• Primary Examiner(s): Metjahic, Safet
• Assistant Examiner(s): GODDARD, BRIAN D
• Application Number:
  US09/893,990
• Publication Number:
  US 20030004919A1
• Time in Patent Office: 1,838 Days
• Field of Search: 707/101, 707/100, 707/102, 707/104.1, 707/10
• US Class Current: 717/102
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/944 Business related
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A system and method for generating a report by a reporting tool of the Systems Applications and Products (SAP) online financial software. An SAP-readable Aspect file is generated and transmitted to the SAP system where the Aspect file may be queried for generating the report. The Aspect file may be generated by a non-SAP bridge program that utilizes a dataset which may be in a SAP or a non-SAP format. Processing the dataset to generate the Aspect file may include data filtration based on selection rules, and may additionally include rolling up the data of the dataset. Two or more of such datasets may be collectively used to form corresponding Aspect files for generating a report based on a query that relates to the corresponding Aspect files. The Aspect file may include procurement data such as purchase order data and invoice data.

Claims

1. A system comprising a processor and a computer readable memory unit coupled to the processor, said memory unit containing instructions that when executed by the processor implement a method for generating a report by a reporting tool of a business information system using data included within an Aspect file, said method comprising executing a bridge program not comprised by the business information system, said executing including:

generating the Aspect file through use of data derived from a dataset, said generating using a first operating system, said Aspect file not readable by the business information system only because the business information system is functioning within a second operating system that differs from the first operating system;

converting the Aspect file into a Temp file that is readable by the business information system; and

transmitting the Temp file to the business information system, wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

2. The system of claim 1, wherein the dataset is dataset formatted such that the dataset is not readable by a program or module of the business information system.

3. The system of claim 1, wherein the dataset is formatted such that the dataset is readable by any program or module of the business information system.

4. A system for generating a report by a reporting tool of a business information system using data included within an Aspect file having rollup records, said system comprising a bridge program not comprised by the business information system, wherein the bridge program is adapted to generate the Aspect file through use of data derived from a dataset and to transmit the Aspect file to the business information system, said dataset having a keygroup, wherein to generate the Aspect file includes to roll up a portion of the dataset with respect to the keygroup, wherein each rollup record has a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the keygroup, wherein the quantity field stores the number of dataset records that have the same rollup keyvalue, wherein each rollup record has a unique rollup keyvalue, and wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

5. The system of claim 4, wherein the bridge program is further adapted to cause the rollup records in the generated Aspect file to be sorted with respect to the keygroup.

6. The system of claim 4, wherein the dataset is formatted such that the dataset is not readable by a program or module of the business information system.

7. The system of claim 4, wherein the dataset is formatted such that the dataset is readable by any program or module of the business information system.

8. The system of claim 4, wherein the bridge program is further adapted to generate a trace file that includes a representative rollup keyvalue of the keygroup and a pointer that points to a portion of the dataset, said portion being correlated with the representative rollup keyvalue.

9. The system of claim 4, wherein the bridge program is further adapted to identify select records of the dataset in accordance with at least one selection rule applied to the dataset, and wherein the portion of the dataset includes the select records so identified.

10. The system of claim 9, wherein to identify the select records includes to accept as input a first date and a second date, wherein the first date is earlier than the second date, and wherein the selection rules do not permit identifying as a select record any record of the dataset having an effective date that is earlier than the first date or later than the second date.

11. The system of claim 4, wherein the dataset is selected from the group consisting of a table, a spreadsheet, and a combination thereof.

12. The system of claim 4, wherein the report relates to procurement data, and wherein the rollup records include the procurement data.

13. The system of claim 12, wherein the procurement data is selected from the group consisting of purchase order data, invoice data, and a combination thereof.

14. A system for generating a report by a reporting tool of a business information system using and combining data included within N Aspect files A₁, A₂, . . . , A_N respectively having rollup records [R]₁, [R]₂, . . . , [R]_N, said N at least 2, said system comprising at least one bridge program not comprised by the business information system, wherein the bridge program is adapted to respectively generate the N Aspect files through use of data derived from select records [S]₁, [S]₂, . . . , [S]_N of N datasets D₁, D₂, . . . D_N, respectively, and to transmit the N Aspect files to the business information system, said select records [S]₁, [S]₂, . . . , [S]_N having a common keygroup, wherein to generate the N Aspect files comprises, for I=1, 2, . . . , and N;

to identify the select records [S]_i in accordance with selection rules applied to D_i; and

to roll up the select records [S]_i with respect to the common keygroup, wherein the rollup records [R]_i corresponding to [S]_i have a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the select records [S]_i, wherein the quantity field stores the number of select records of [S]_i that have the same rollup keyvalue, wherein each rollup record [R]_i has a unique rollup keyvalue, and wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

15. The system of claim 14, wherein a first dataset of the N datasets is formatted such that the dataset is not readable by a program or module of the business information system.

16. The system of claim 14, wherein a first dataset of the N datasets is formatted such that the dataset is readable by any program or module of the business information system.

17. The system of claim 14, wherein a first dataset of the N datasets and a second dataset of the N datasets have different formats.

18. The system of claim 14, wherein the datasets D₁, D₂, . . . , D_N have formats F₁, F₂, . . . , F_N, respectively, wherein the at least one bridge program comprises N bridge programs P₁, P₂, . . . , P_N respectively keyed to the formats F₁, F₂, . . . , F_N for respectively generating the Aspect files A₁, A₂, . . . , A_N.

19. The system of claim 14, wherein the datasets D₁, D₂, . . . , D_N have formats F₁, F₂, . . . , F_N, respectively, and wherein the at least one bridge program consists of one bridge program having logical paths L₁, L₂, . . . , L_N respectively keyed to the formats F₁, F₂, . . . , F_N for respectively generating the Aspect files A₁, A₂, . . . , A_N.

20. The system of claim 14, wherein the selection rules are the same for each of the N datasets.

21. The system of claim 14, wherein the report relates to procurement data, and wherein the rollup records [R]₁, [R]₂, . . . , [R]_N include the procurement data.

22. The system of claim 21, wherein the procurement data is selected from the group consisting of purchase order data, invoice data, and a combination thereof.

23. A method for generating a report by a reporting tool of a business information system using data included within an Aspect file, said method comprising executing a bridge program not comprised by the business information system, said executing including:

generating the Aspect file through use of data derived from a dataset, said generating using a first operating system, said Aspect file not readable by the business information system only because the business information system is functioning within a second operating system that differs from the first operating system;

converting the Aspect file into a Temp file that is readable by the business information system; and

transmitting the Temp file to the business information system, wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

24. The method of claim 23, wherein the dataset is formatted such that the dataset is not readable by a program or module of the business information system.

25. The method of claim 23, wherein the dataset is formatted such that die dataset is readable by any program or module of the business information system.

26. A method for generating a report by a reporting tool of a business information system using data included within an Aspect file having roll up records, said method comprising:

providing a dataset having a keygroup; and

executing a bridge program not comprised by the business information system, including generating the Aspect file, said generating comprising rolling up a portion of the dataset with respect to the keygroup, wherein each rollup record has a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the keygroup, wherein the quantity field stores the number of dataset records that have the same rollup keyvalue, wherein each rollup record has a unique rollup keyvalue, and

wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

27. The method of claim 26, wherein generating the Aspect file includes causing the rollup records in the generated Aspect file to be sorted with respect to the keygroup.

28. The method of claim 26, wherein the dataset is formatted such that the dataset is not readable by a program or module of the business information system.

29. The method of claim 26, wherein the dataset is formatted such that the dataset is readable by any program or module of the business information system.

30. The method of claim 26, further comprising generating a trace file that includes a representative rollup keyvalue of the keygroup and a pointer that points to a portion of the dataset, said portion being correlated with the representative rollup keyvalue.

31. The method of claim 26, further comprising identifying select records of the dataset in accordance with at least one selection rule applied to the dataset, said portion of the dataset including the select records so identified.

32. The method of claim 31, said identifying including accepting as input a first date and a second date, said first date earlier than said second date, said selection rules not permitting said identifying to identity as a select record any record of the dataset having an effective date that is earlier than the first date or later than the second date.

33. The method of claim 26, wherein the dataset is selected from the group consisting of a table, a spreadsheet, and a combination thereof.

34. The method of claim 26, wherein the report relates to procurement data, and wherein the rollup records include the procurement data.

35. The method of claim 34, wherein the procurement data is selected from the group consisting of purchase order data, invoice data, and a combination thereof.

36. The method of claim 26, further comprising:

transmitting the Aspect file to the business information system where the Aspect file becomes a Temp file having the rollup records;

making a query to sum over the quantity field for a subset of the rollup records of the Temp file, wherein the subset is determined by the query, and wherein the query is adapted to being executed by a module of the business information system; and

executing the query by the module including returning a result of the query.

37. A method for generating a report by a reporting tool of a business information system using and combining data included within N Aspect files A₁, A₂, . . . , A_N respectively having rollup records [R]₁, [R]₂, . . . , [R]_N, said N at least 2, said method comprising providing N datasets D₁, D₂, . . . , D_N having a common keygroup, and for I=1, 2, . . . , and N executing a bridge program not comprised by the business information system, including:

identifying select records [S]_i of the dataset D_i, said identifying in accordance with selection rules applied to D_i; and

rolling up the select records [S]_i with respect to the common keygroup, wherein the rollup records [R]_i corresponding to [S]_i have a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the select records [S]_i, wherein the quantity field stores the number of select records of [S]_i that have the same rollup keyvalue, wherein each rollup record [R]_i has a unique rollup keyvalue, and wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

38. The method of claim 37, wherein a first dataset of the N datasets is formatted such that the dataset is not readable by a program or module of the business information system.

39. The method of claim 37, wherein a first dataset of the N datasets is formatted such that the dataset is readable by any program or module of the business information system.

40. The method of claim 37, wherein a first dataset of the N datasets and a second dataset of the N datasets have different formats.

41. The method of claim 37, wherein the datasets D₁, D₂, . . . , D_N have formats F₁, F₂, . . . , F_N respectively, wherein the at least one bridge program comprises N bridge programs P₁, P₂, . . . , P_N respectively keyed to the formats F₁, F₂, . . . , F_N for respectively generating the Aspect files A₁, A₂, . . . , A_N.

42. The method of claim 37, wherein the datasets D₁, D₂, . . . , D_N have formats F₁, F₂, . . . , F_N respectively, and wherein the at least one bridge program consists of one bridge program having logical paths L₁, L₂, . . . , L_N respectively keyed to the formats F₁, F₂, . . . , F_N for respectively generating the Aspect files A₁, A₂, . . . , A_N.

43. The method of claim 37, wherein the selection rules are the same for each of the N datasets.

44. The method of claim 37, wherein the report relates to procurement data, and wherein the rollup records [R]₁, [R]₂, . . . , [R]_N include the procurement data.

45. The method of claim 44, wherein the procurement data is selected from the group consisting of purchase order data, invoice data, and a combination thereof.

46. The method of claim 37, further comprising:

transmitting the Aspect file A₁ to the business information system where the Aspect file A₁ becomes a Temp file T_i having flue rollup records [R]_i for I=1, 2, . . . , and N;

making a query to sum over the quantity field for a subset of the rollup records of the N Temp files in composite, wherein the subset is determined by the query, and wherein the query is adapted to being executed by a module of the business information system; and

executing the query by the module including returning a result of the query.

47. A computer program product, comprising a computer usable medium having a computer readable program code embodied therein, said computer readable program code comprising an algorithm adapted to implement a method for generating a report by a reporting tool of a business information system using data included within an Aspect file, said method comprising executing a bridge program not comprised by the business information system, said executing including:

generating the Aspect file through use of data derived from a dataset, said generating using a first operating system, said Aspect file not readable by the business information system only because the business information system is functioning within a second operating system that differs from the first operating system;

converting the Aspect file into a Temp file that is readable by the business information system; and

transmitting the Temp file to the business information system, wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

48. A computer program product, comprising a computer usable medium having a computer readable program code embodied therein for generating a report by a reporting tool of a business information system using data included within an Aspect file having rollup records, said program code comprising a bridge program not comprised by the business in formation system, wherein the bridge program is adapted to generate the Aspect file through use of data derived from a dataset and to transmit the Aspect file to the business information system, said dataset having a keygroup, wherein to generate the Aspect file includes to roll up a portion of the dataset with respect to the keygroup, wherein each rollup record has a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the keygroup, wherein the quantity field stores the number of dataset records that have the same rollup keyvalue, wherein each rollup record has a unique rollup keyvalue, and wherein the business information system has reporting capabilities in conjunction with a business data warehouse.

49. A computer program product, comprising a computer usable medium having a computer readable program code embodied therein for generating a report by a reporting tool of a business information system using and combining data included within N Aspect files A₁, A₂, . . . , A_N respectively having rollup records [R]₁, [R]₂, . . . , [R]_N, said N at least 2, said program code comprising at least one bridge program not comprised by the business information system, wherein the bridge program is adapted to respectively generate the N Aspect files through use of data derived from select records [S]₁, [S]₂, . . . , [S]_N of N datasets D₁, D₂, . . . , D_N, respectively, and to transmit the N Aspect files to the business information system, said select records [S]₁, [S]₂, . . . , [S]_N having a common keygroup, wherein to generate the N Aspect files comprises, for I=1, 2, . . . , and N:

to identify the select records [S]_i in accordance with selection rules applied to D_i; and

to roll up the select records [S]_i with respect to the common keygroup, wherein the rollup records [R]_i corresponding to [S]_i have a rollup field and a quantity field, wherein the rollup field stores a rollup keyvalue of the select records [S]_i, wherein the quantity field stores the number of select records of [S]_i that have the same rollup keyvalue, wherein each rollup record [R]_i has a unique rollup keyvalue, and wherein the business information system has reporting capabilities in conjunction with a business data warehouse.