Designing business content for reporting

• US 8,589,311 B2
• Filed: 08/26/2003
• Issued: 11/19/2013
• Est. Priority Date: 06/13/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Bhatt, Ankur, Sarangarajan, Raghunandan
• Primary Examiner(s): GILKEY, CARRIE STRODER
• Application Number:
  US10/648,108
• Publication Number:
  US 20040252134A1
• Time in Patent Office: 3,738 Days
• Field of Search: 705/1, 705/342
• US Class Current: 705/342
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

Techniques are disclosed for designing business content for reporting tools. In one general aspect, the invention provides for receiving a user selection of a business object having associated attributes and displaying a view of the attributes. A user selection of one or more of the attributes is received, indicating the selected one or more attributes are to be displayed in a report generated in the external reporting application. The selected one or more attributes are added to a business content structure. Data associated with the business content structure is retrieved and an output file is generated. The reporting application can use the output file to generate the report that includes the business content structure and the data associated therewith. The business content structure can be stored in a database and later retrieved to generate an output file, allowing a report with current data to be generated by the reporting application.

Claims

1. A computer-implemented method of providing object-based content to be reported in an external computer-implemented general reporting application, the method comprising:

providing an electronic storage repository of business database objects from which object instances are able to be generated, which business database objects each have one or more attributes for which applicable data are able to be provided for a generated object instance;

receiving, in a data processing system comprising at least one computer, a user selection of one of the business database objects, wherein generated instances of the selected object have data for attributes of the object;

displaying on a display device a view that includes;

i) the selected business database object in a first portion of the view, ii) at least some of the attributes associated with the selected business database object in a second portion of the view, iii) a plurality of business objects each having associated attributes, wherein each of the business objects has a defined relationship to the selected business database object in a third portion of the view, and iv) at least some of the attributes for the plurality of related business objects in a fourth portion of the view;

receiving in the data processing system a user selection of at least one of the displayed one or more attributes associated with the selected business database object, and a user selection of at least one of the displayed attributes for the plurality of related business objects, and adding the selected attributes to an electronic business content structure of selected attributes;

defining a report layout using the electronic business content structure and the selected attributes, wherein the report layout defines the structure of one or more reports;

executing a query of records in an electronic database and retrieving, for each of the records that meet the query, attribute data for each of the attributes in the electronic business content structure;

generating, in the data processing system and before reporting run-time, an output electronic file that the external computer-implemented reporting application can use to generate a report, the report to include the electronic business content structure and the attribute data associated therewith, and to be structured according to the report layout;

determining, at the reporting run-time, one of a plurality of external computer-implemented reporting applications for use in generating the report; and

launching the determined reporting application using the output electronic file and generating the report in the determined reporting application according to the previously defined report layout.

2. The method of claim 1 wherein a business content design wizard assists in defining the electronic business content structure.

3. The method of claim 1 wherein the electronic business content structure represents meta-data information.

4. The method of claim 1 further comprising displaying on the display device a view of a plurality of electronic business content structures and receiving a user selection of one of the electronic business content structures to be included in a report.

5. The method of claim 1 further comprising defining a calculated field to be included in the electronic business content structure, wherein the calculated field is associated with a function that takes one or more business object attributes as input, and uses a formula to compute a resultant value for the calculated field based on the input.

6. The method of claim 5 wherein the electronic business content structure represents meta-data information.

7. The method of claim 5 wherein the resultant value is included in the output electronic file.

8. The method of claim 1 further comprising persistently storing the electronic business content structure in an electronic database.

9. The method of claim 8 wherein the electronic business content structure is stored as an XML document in the electronic database, and wherein the electronic business content structure attributes correspond to tags in the XML document.

10. The method of claim 1 wherein the database query is an SQL query that uses the concept of derived tables.

11. The method of claim 1 wherein the output electronic file is an ActiveX Data Object Recordset.

12. The method of claim 1 wherein generating the output electronic file that the external computer-implemented reporting application can use to generate the report further comprises transferring the output electronic file to a reporting-tool-specific interface component capable of plug-and-play interaction with the external computer-implemented reporting application.

26. The method of claim 1, further comprising displaying a pictorial representation of the selected business database object and one or more of the related business objects.

13. A computer-implemented method of providing object-based content to be reported in an external computer-implemented general reporting application, the method comprising:

receiving, in a data processing system comprising at least one computer, a user selection of a business database object having associated attributes, wherein generated instances of the selected object have data for the associated attributes;

displaying on a display device a view that includes;

i) the selected business database object in a first portion of the view, ii) at least some of the attributes associated with the selected business database object in a second portion of the view, iii) a plurality of business objects each having associated attributes, wherein each of the business objects has a defined relationship to the selected business database object in a third portion of the view, and iv) at least some of the attributes for the plurality of related business objects in a fourth portion of the view;

receiving in the data processing system a user selection of at least one of the displayed attributes associated with the selected business database object, and a user selection of at least one of the displayed attributes for the plurality of related business objects, and adding the selected attributes to an electronic business content structure of selected attributes;

persistently storing the electronic business content structure in an electronic database so that it can later be retrieved and used to generate, before reporting run-time, an output file that the external computer-implemented general reporting application can use to generate a report with current data; and

defining a report layout using the electronic business content structure and the selected attributes, wherein the report layout defines the structure of one or more reports.

14. A non-transitory computer-readable medium with program instructions stored thereon that when executed perform the following functions for providing object-based content to be reported in an external computer-implemented general reporting application:

provides an electronic storage repository of business database objects from which object instances are able to be generated, which business database objects each have one or more attributes for which applicable data are able to be provided for a generated object instance;

receives, in a data processing system comprising at least one computer, a user selection of one of the business database objects, wherein generated instances of the selected object have data for attributes of the object;

displays on a display device a view that includes;

i) the selected business database object in a first portion of the view, ii) at least some of the attributes associated with the selected business database object in a second portion of the view, iii) a plurality of business objects each having associated attributes, wherein each of the business objects has a defined relationship to the selected business database object in a third portion of the view, and iv) at least some of the attributes for the plurality of related business objects in a fourth portion of the view;

receives in the data processing system a user selection of at least one of the displayed one or more attributes associated with the selected business database object, and a user selection of at least one of the displayed attributes for the plurality of related business objects, and adding the selected attributes to an electronic business content structure of selected attributes;

defines a report layout using the electronic business content structure and the selected attributes, wherein the report layout defines the structure of one or more reports;

executes a query of records in an electronic database and retrieves, for each of the records that meet the query, attribute data for each of the attributes in the electronic business content structure;

generates, in the data processing system and before reporting run-time, an output electronic file that the external computer-implemented reporting application can use to generate a report, the report to include the electronic business content structure and the attribute data associated therewith, and to be structured according to the report layout;

determines, at the reporting run-time, one of a plurality of external computer-implemented reporting applications for use in generating the report; and

launches the determined reporting application using the output electronic file and generates the report in the determined reporting application according to the previously defined report layout.

15. The medium of claim 14 wherein a business content design wizard assists in defining the electronic business content structure.

16. The medium of claim 14 wherein the electronic business content structure represents meta-data information.

17. The medium of claim 14 further comprising instructions that when executed displays on the display device a view of a plurality of electronic business content structures and receives a user selection of one of the electronic business content structures to be included in a report.

18. The medium of claim 14 further comprising instructions that when executed defines a calculated field to be included in the electronic business content structure, wherein the calculated field is associated with a function that takes one or more business object attributes as input, and uses a formula to compute a resultant value for the calculated field based on the input.

19. The medium of claim 18 wherein the electronic business content structure represents meta-data information.

20. The medium of claim 18 wherein the resultant value is included in the output electronic file.

21. The medium of claim 14 further comprising instructions that when executed persistently stores the electronic business content structure in an electronic database.

22. The medium of claim 21 wherein the electronic business content structure is stored as an XML document in the electronic database, and wherein the electronic business content structure attributes correspond to tags in the XML document.

23. The medium of claim 14 wherein the database query is an SQL query that uses the concept of derived tables.

24. The medium of claim 14 wherein the output electronic file is an ActiveX Data Object Recordset.

25. The medium of claim 14 wherein generating the output electronic file that the external computer-implemented reporting application can use to generate the report further comprises transferring the output electronic file to a reporting-tool-specific interface component capable of plug-and-play interaction with the external computer-implemented reporting application.

27. The medium of claim 14, further comprising instructions that when executed display a pictorial representation of the selected business database object and one or more of the related business objects.