Displaying historical data associated with data values within business intelligence reports

• US 9,946,804 B2
• Filed: 08/19/2013
• Issued: 04/17/2018
• Est. Priority Date: 08/19/2013
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Chan, Pak Man, Chiu, Nicholas, Seblani, Mehdi
• Primary Examiner(s): Mills, Frank D
• Application Number:
  US13/970,554
• Publication Number:
  US 20150052099A1
• Time in Patent Office: 1,702 Days
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: G06Q 10/063 Operations research, analysis or management

Abstract

The current subject matter describes displaying historical data associated with one or more data values within a business intelligence report. A graphical user interface executed by a computing device can receive, from a user, a request for display of historical data associated with a specified/selected data value in a business intelligence report. Subsequently, a representational state transfer engine (RESTful engine), which can be connected to a server system connected to the computing device, can execute a representational state transfer service (RESTful service) to fetch historical data from current and past instances associated with the data value. Then, the RESTful engine can write the fetched historical data to a file. The RESTful engine can generate or determine a uniform resource locator (URL) to the file, and can send the URL to the computing device. When the URL is selected by the user, the computing device can display the file.

Claims

1. A method comprising:

receiving, at a client browser of a computing device, a first request to display historical data associated with one or more data values of a business intelligence report;

sending, by the computing device to a server system executed in an application layer, a second request for generating the historical data in response to the first request, the server system sending to a representational state transfer engine a third request for a uniform resource locator identifying a location of a file to be filled with the historical data in response to the second request, the representational state transfer engine executing in response to the third request a representational state transfer service to fetch the historical data from past instances of the business intelligence report and to fill the file with the historical data, the representational state transfer service generating the uniform resource locator specific to the third request, the representational state transfer engine sending the uniform resource locator to the server system;

receiving, by the computing device and from the server system, the uniform resource locator; and

displaying the uniform resource locator on the client browser of the computing device, the file with the historical data being displayed on the client browser when the uniform resource locator is selected.

2. The method of claim 1, wherein the file is a comma separated values (CSV) file.

3. The method of claim 1, wherein the uniform resource locator is a web link.

4. The method of claim 1, wherein the fetching of the historical data and the filling of the file with the historical data comprises:

obtaining, at the representational state transfer engine, past instances of the business intelligence report;

generating, by the representational state transfer engine, identifiers identifying the past instances;

fetching, by the representational state transfer engine, data included in associated rows of the past instances identified by the identifiers; and

writing, by the representational state transfer engine, the fetched data in the file.

5. The method of claim 1, wherein the representational state transfer engine comprises at least one data processor that executes the representational state transfer service.

6. The method of claim 1, wherein the representational state transfer service is a computing application hosted by the server system to fetch and deliver the historical data to the computing device.

7. The method of claim 1, wherein the past instances of the business intelligence report are saved in one or more databases connected to the server system.

8. The method of claim 1, wherein the computing device is connected to the server system via a communication network.

9. The method of claim 8, wherein the communication network is Internet.

10. The method of claim 1, wherein the historical data in the file is displayed on the client browser in a graphical format, the graphical format being at least one of:

a bar chart, a pie-chart, and a hierarchical tree structure.

11. A method comprising:

executing a representational state transfer engine on one or more processors;

fetching, by the representational state transfer engine in response to receipt of a request from a server system for a uniform resource locator identifying a location of a file to be filled with historical data, the historical data from past instances of a report to fill the file with the historical data;

generating, by the representational state transfer engine, the uniform resource locator specific to the request; and

sending, by the representational state transfer engine, the uniform resource locator to the server system for use by a client browser of a computing device from which the server system received the request to cause the client browser to display the file with the historical data being when the uniform resource locator is selected.

12. The method of claim 11, wherein the filling of the file with the historical data comprises:

writing, by the representational state transfer engine, the fetched historical data in the file.

13. The method of claim 11, wherein the report is executed on an operating system of the computing device, the operating system being independent of a structure of the report.

14. A system comprising:

a computing device comprising a client browser to receive a request to display historical data associated with one or more data values of a business intelligence report, the historical data being displayed on the client browser in a graphical format, the graphical format being at least one of;

a bar chart, a pie-chart, and a hierarchical tree structure, the computing device comprising at least one processor; and

a server system connected to the computing device via a communication network, the server system receiving the request to display historical data, the server system executing a representational state transfer engine executing in response to a second request from the server system to the representational state transfer engine for a uniform resource locator identifying a location of a file to be filled with the historical data a representational state transfer service to fetch the historical data from past instances of the business intelligence report and to fill the file with the historical data, the representational state transfer service generating the uniform resource locator that identifies the location of the file filled with the historical data, the server system sending a uniform resource locator identifying a location of the file to the computing device, the computing device displaying the uniform resource locator on the client browser, the server system comprising at least one processor.

15. The system of claim 14, further comprising:

at least one database to store the past instances of the business intelligence report.

16. The system of claim 14, wherein the file is a comma separated values (CSV) file.

17. The system of claim 14, wherein the uniform resource locator is a web link.

18. The system of claim 14, wherein the client browser is displayed on a display screen of the computing device.