IP Library Granted Patent US 8,712,956
Granted Patent B2
US 8,712,956 · App. 12/413,882 · Granted Apr 29, 2014

Systems and methods to provide report part via a web service

Inventors: David J. M. Brunner (Vanves, FR); Nadir Loutfi (Osny, FR)
Assignee: SAP AG
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,712,956
App. No.
12/413,882
Granted
Apr 29, 2014
Kind
B2
Abstract

Some aspects include reception of a selection of a part of a report, the selected report part associated with queries of a semantic layer, and creation of a description of a Web Service call to return contents of the selected report part. In some aspects, a Web Service call associated with a part of a report is received, the report part associated with queries of a semantic layer, and a query is determined based on the Web Service call to return contents of the report part.

Claims (167)

1. A non transitory computer-readable medium having stored thereon program code, the program code executable by a computer to:

receive a user selection of a report;

display the user selected report in a view in a graphical user interface;

receive a user selection of a part of the report displayed in the view in the graphical user interface, the user selected report part associated with queries of a semantic layer, the report including a report part other than the user selected report part;

display, in a single view in a graphical user interface, (a) the user selected report part and (b) a control to initiate creation of a description of a Web Service call to return contents of the user selected report part;

receive a user selection of the control to initiate creation of a description of a Web Service call to return contents of the user selected report part;

in response to the user selection of the control to initiate creation of the description of the Web Service call to return contents of the user selected report part, create the description of the Web Service call to return contents of the user selected report part without creating a description of a Web Service call to return contents of the report part other than the user selected report part; and

store the description of the Web Service call in a repository.

2. A medium according to claim 1 , the program code further executable by a computer to:

create a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing filtering parameters,

wherein the second Web Service call is to return filtered contents of the selected report part based on the filtering parameters.

3. A medium according to claim 2 , the program code further executable by a computer to:

create a description of a third Web Service call corresponding to the selected report part, the third Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the third Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

4. A medium according to claim 3 ,

wherein the third Web Service call further provides combination parameters, and

wherein the third Web Service call is to return drilled-down and filtered contents of the selected report part based on the combination parameters.

5. A medium according to claim 1 , the program code further executable by a computer to:

create a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the second Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

6. A medium according to claim 5 ,

wherein the second Web Service call further provides filtering parameters, and

wherein the second Web Service call is to return drilled-down and filtered contents of the selected report part based on the drilling and filtering parameters.

7. A medium according to claim 1 , the program code further executable by a computer to:

create a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing formatting parameters to specify a format of the formatted contents,

wherein the second Web Service call is to return formatted contents of the selected report part based on the formatting parameters.

8. A medium according to claim 7 , the program code further executable by a computer to:

create a description of a third Web Service call corresponding to the selected report part, the third Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target; and

create a description of a fourth Web Service call corresponding to the selected report part, the fourth Web Service call providing filtering parameters,

wherein the third Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters, and

wherein the fourth Web Service call is to return filtered contents of the selected report part based on the filtering parameters.

9. A medium according to claim 1 , wherein the report includes a chart or table;

wherein the display of the report in the view in the graphical user interface includes a display of the chart or table of the report;

wherein the user selected report part includes the chart or table of the report; and

wherein the display, in a single view in a graphical user interface, the user selected report part and a control to initiate creation of a description of a Web Service call to return contents of the user selected report part comprises:

display, in a single view in a graphical user interface, the user selected chart or table and a control to initiate creation of a description of a Web Service call to return contents of the chart or table.

10. A non transitory computer-readable medium having stored thereon program code, the program code executable by a computer to:

receive a Web Service call that is associated with: (i) a part of a report and (ii) a Web Service, the report part associated with queries of a semantic layer, the report including a report part other than the report part associated with the Web Service call, the Web Service not associated with a Web Service call that is associated with the other report part; and

determine, based on the Web Service call that is associated with the part of the report and the Web Service, a query to return contents of the report part;

wherein the Web Service includes a plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository.

11. A medium according to claim 10 , wherein the program code executable by a computer to determine the query comprises program code executable by a computer to:

determine, based on the Web Service call, a second query to return a reference to the report part;

transmit the second query to a repository;

receive the reference to the report part from the repository; and

determine the query to return contents of the report part based on the reference to the report part.

12. A medium according to claim 11 , wherein the program code is further executable by a computer to:

transmit the query to a report server; and

receive the contents of the report part from the report server.

13. A medium according to claim 10 , wherein the program code is further executable by a computer to:

transmit the query to a report server;

receive the contents of the report part from the report server; and

create an HTTP message including the contents of the report part.

14. A medium according to claim 10 , wherein the Web Service call is associated with filtering parameters, and wherein the program code executable by a computer to determine the query comprises program code executable by a computer to:

determine, based on the Web Service call, a query to return filtered contents of the report part based on the filtering parameters.

15. A medium according to claim 10 , wherein the Web Service call is associated with drilling parameters to specify a drilling direction, drilling steps and a drilling target, and wherein the program code executable by a computer to determine the query comprises program code executable by a computer to:

determine, based on the Web Service call, a query to return drilled-down contents of the report part based on the drilling parameters.

16. A medium according to claim 10 , wherein the Web Service call is associated with formatting parameters to specify a format of the formatted contents, and wherein the program code executable by a computer to determine the query comprises program code executable by a computer to:

determine, based on the Web Service call, a query to return formatted contents of the report part based on the formatting parameters.

17. A medium according to claim 10 , wherein the plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository comprise:

a first description of a Web Service call that is to return contents of the report part and stored in a repository; and

a second description of a Web Service call that is to return filtered contents of the report part, is stored in a repository and is different than the first description of a Web Service call.

18. A system comprising:

a semantic layer;

a computer to provide a Web Service creator to: (i) receive a user selection of a report, (ii) display the user selected report in a view in a graphical user interface, (iii) receive a user selection of a part of the report displayed in the view in the graphical user interface, the user selected report part associated with queries of the semantic layer, the report including a report part other than the user selected report part, (iv) display, in a single view in a graphical user interface, (a) the user selected report part and (b) a control to initiate creation of a description of a Web Service call to return contents of the user selected report part, (v) receive a user selection of the control to initiate creation of a description of a Web Service call to return contents of the user selected report part, and (vi) in response to the user selection of the control to initiate creation of the description of the Web Service call to return contents of the user selected report part, issue an instruction to create the description of the Web Service call to return contents of the user selected report part;

a computer to provide a report server to: (i) receive the instruction to create the description of the Web Service call to return contents of the user selected report part, and (ii) in response to the instruction to create the description of the Web Service call to return contents of the user selected report part, create the description of the Web Service call to return contents of the user selected report part without creating a description of a Web Service call to return contents of the report part other than the user selected report part; and

a repository to store the description of the Web Service call.

19. A system according to claim 18 , the report server further to:

create a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing filtering parameters,

wherein the second Web Service call is to return filtered contents of the selected report part based on the filtering parameters.

20. A system according to claim 19 , the report server further to:

create a description of a third Web Service call corresponding to the selected report part, the third Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the third Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

21. A system according to claim 18 , the report server further to:

create a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the second Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

22. A system according to claim 21 ,

wherein the second Web Service call further provides filtering parameters, and

wherein the second Web Service call is to return drilled-down and filtered contents of the selected report part based on the drilling and filtering parameters.

23. A system according to claim 18 , further comprising:

a repository to store the contents of the report and the description of the Web Service call.

24. A system according to claim 18 , wherein the report includes a chart or table;

wherein the display of the report in the view in the graphical user interface includes a display of the chart or table of the report;

wherein the user selected report part includes the chart or table of the report; and

wherein the display, in a single view in a graphical user interface, the user selected report part and a control to initiate creation of a description of a Web Service call to return contents of the user selected report part comprises:

display, in a single view in a graphical user interface, the user selected chart or table and a control to initiate creation of a description of a Web Service call to return contents of the chart or table.

25. A system comprising:

a semantic layer;

a computer to provide a Web Server to: (a) receive a Web Service call that is associated with: (i) a part of a report and (ii) a Web Service, the report part associated with queries of the semantic layer, the report including a report part other than the report part associated with the Web Service call, the Web Service not associated with a Web Service call that is associated with the other report part, and (b) determine, based on the Web Service call that is associated with the part of the report and the Web Service, a query to return contents of the report part; and

a computer to provide a report server to receive the query and to return the contents of the report part to the Web Server;

wherein the Web Service includes a plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository.

26. A system according to claim 25 , further comprising:

a repository to store the contents of the report part, and to transmit the contents of the report part to the report server.

27. A system according to claim 26 , the repository to store a description of the Web Service call.

28. A system according to claim 25 , wherein the Web Server is further to create an HTTP message including the contents of the report part.

29. A system according to claim 25 , wherein the Web Service call is associated with filtering parameters, wherein the query is to return filtered contents of the report part based on the filtering parameters, and wherein the contents of the report part returned by the report server are filtered based on the filtering parameters.

30. A system according to claim 25 , wherein the Web Service call is associated with drilling parameters to specify a drilling direction, drilling steps and a drilling target, wherein the query is to return drilled-down contents of the report part based on the drilling parameters, and wherein the contents of the report part returned by the report server are drilled-down based on the drilling parameters.

31. A system according to claim 30 ,

wherein the Web Service call is associated with filtering parameters, and

wherein the query is to return drilled-down and filtered contents of the selected report part based on the drilling and filtering parameters.

32. A system according to claim 25 , wherein the plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository comprise:

a first description of a Web Service call that is to return contents of the report part and stored in a repository; and

a second description of a Web Service call that is to return filtered contents of the report part, is stored in a repository and is different than the first description of a Web Service call.

33. A method comprising:

receiving a user selection of a report;

displaying the user selected report in a view in a graphical user interface;

receiving, by a computer, a user selection of a part of the report displayed in the view in the graphical user interface, the user selected report part associated with queries of a semantic layer, the report including a report part other than the user selected report part;

displaying, in a single view in a graphical user interface, (a) the user selected report part and (b) a control to initiate creation of a description of a Web Service call to return contents of the user selected report part;

receiving, by the computer, a user selection of the control to initiate creation of a description of a Web Service call to return contents of the user selected report part;

in response to the user selection of the control to initiate creation of the description of the Web Service call to return contents of the user selected report part, issuing, by the computer, an instruction to create the description of the Web Service call to return contents of the user selected report part;

in response to the instruction to create the description of the Web Service call to return contents of the user selected report part, creating, by a computer, the description of the Web Service call to return contents of the user selected report part without creating a description of a Web Service call to return contents of the report part other than the user selected report part; and

storing the description of the Web Service call in a repository.

34. A method according to claim 33 , the method further comprising:

creating a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing filtering parameters,

wherein the second Web Service call is to return filtered contents of the selected report part based on the filtering parameters.

35. A method according to claim 34 , the method further comprising:

creating a description of a third Web Service call corresponding to the selected report part, the third Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the third Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

36. A method according to claim 35 ,

wherein the third Web Service call further provides combination parameters, and

wherein the third Web Service call is to return drilled-down and filtered contents of the selected report part based on the combination parameters.

37. A method according to claim 33 , the method further comprising:

creating a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target,

wherein the second Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters.

38. A method according to claim 37 ,

wherein the second Web Service call further provides filtering parameters, and

wherein the second Web Service call is to return drilled-down and filtered contents of the selected report part based on the drilling and filtering parameters.

39. A method according to claim 33 , the method further comprising:

creating a description of a second Web Service call corresponding to the selected report part, the second Web Service call providing formatting parameters to specify a format of the formatted contents,

wherein the second Web Service call is to return formatted contents of the selected report part based on the formatting parameters.

40. A method according to claim 39 , the method further comprising::

creating a description of a third Web Service call corresponding to the selected report part, the third Web Service call providing drilling parameters to specify a drilling direction, drilling steps and a drilling target; and

creating a description of a fourth Web Service call corresponding to the selected report part, the fourth Web Service call providing filtering parameters,

wherein the third Web Service call is to return drilled-down contents of the selected report part based on the drilling parameters, and

wherein the fourth Web Service call is to return filtered contents of the selected report part based on the filtering parameters.

41. A method according to claim 33 , wherein the report includes a chart or table;

wherein the display of the report in the view in the graphical user interface includes a display of the chart or table of the report;

wherein the user selected report part includes the chart or table of the report; and

wherein the displaying, in a single view in a graphical user interface, the user selected report part and a control to initiate creation of a description of a Web Service call to return contents of the user selected report part comprises:

displaying, in a single view in a graphical user interface, the user selected chart or table and a control to initiate creation of a description of a Web Service call to return contents of the chart or table.

42. A method comprising:

receiving, by a computer, a Web Service call that is associated with: (i) a part of a report and (ii) a Web Service, the report part associated with queries of a semantic layer, the report including a report part other than the report part associated with the Web Service call, the Web Service not associated with a Web Service call that is associated with the other report part; and

determining, by a computer and based on the Web Service call that is associated with the part of the report and the Web Service, a query to return contents of the report part;

wherein the Web Service includes a plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository.

43. A method according to claim 42 , the method further comprising:

determining, based on the Web Service call, a second query to return a reference to the report part;

transmitting the second query to a repository;

receiving the reference to the report part from the repository; and

determining the query to return contents of the report part based on the reference to the report part.

44. A method according to claim 43 , the method further comprising:

transmitting the query to a report server; and

receiving the contents of the report part from the report server.

45. A method according to claim 42 , the method further comprising:

transmitting the query to a report server;

receiving the contents of the report part from the report server; and

creating an HTTP message including the contents of the report part.

46. A method according to claim 42 , wherein the Web Service call is associated with filtering parameters, and

wherein the method further comprises:

determining, based on the Web Service call, a query to return filtered contents of the report part based on the filtering parameters.

47. A method according to claim 42 , wherein the Web Service call is associated with drilling parameters to specify a drilling direction, drilling steps and a drilling target, and

wherein the method further comprises:

determining, based on the Web Service call, a query to return drilled-down contents of the report part based on the drilling parameters.

48. A method according to claim 42 , wherein the Web Service call is associated with formatting parameters to specify a format of the formatted contents, and \

wherein the method further comprises:

determining, based on the Web Service call, a query to return formatted contents of the report part based on the formatting parameters.

49. A method according to claim 42 , wherein the plurality of descriptions of Web Service calls that are to return contents of the report part and are stored in a repository comprise:

a first description of a Web Service call that is to return contents of the report part and stored in a repository; and

a second description of a Web Service call that is to return filtered contents of the report part, is stored in a repository and is different than the first description of a Web Service call.

Assignments (3)
CHANGE OF NAME Recorded Jan 26, 2026
From: BUSINESS OBJECTS SOFTWARE LIMITED
To: SAP IRELAND LIMITED
Reel/Frame 074510/0354 →
CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE PREVIOUSLY RECORDED ON REEL 022468 FRAME 0494. ASSIGNOR(S) HEREBY CONFIRMS THE PROPER ASSIGNEE SHOULD BE: BUSINESS OBJECTS SOFTWARE LIMITED, 25/28 NORTH WALL QUAY, DUBLIN, 1, IRELAND. Recorded May 14, 2009
From: BRUNNER, DAVID J.M.; LOUTFI, NADIR
To: BUSINESS OBJECTS SOFTWARE LIMITED
Reel/Frame 022686/0495 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 30, 2009
From: BRUNNER, DAVID J.M.; LOUTFI, NADIR
To: SAP AG
Reel/Frame 022468/0494 →
Continuity (1)
Related Publication 20100250486A1 · Sep 30, 2010