IP Library Granted Patent US 12,130,828
Granted Patent B2
US 12,130,828 · App. 17/529,006 · Granted Oct 29, 2024

Managing query models based on shared objects

Inventors: Justin Wong (Burnaby, CA); Rui Liu (Vancouver, CA); Clarence Chuahuico (Port Coquitlam, CA); Semuel Kadarusman (Burnaby, CA); Veljko Jovanovic (Vancouver, CA)
Assignee: BUSINESS OBJECTS SOFTWARE LTD
G06F16/248G06F16/242G06F16/258G06F16/26
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 12,130,828
App. No.
17/529,006
Granted
Oct 29, 2024
Kind
B2
Abstract

Some embodiments provide a program that generates a first query for a first visualization based on a first query model associated with the first visualization. The first query model includes a first reference to a shared object. The program further sends the first query to a computing system. The program also receives from the computing system a first set of data. The program further generates the first visualization based on the first set of data. The program also generates a second query for a second visualization based on a second query model associated with the second visualization. The second query model includes a second reference to the shared object. The program further sends the second query to the computing system. The program also receives from the computing system a second set of data. The program further generates the second visualization based on the second set of data.

Claims (61)

1. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:

generating a first query for a first set of data corresponding to a first visualization based on a first query model associated with the first visualization, the first query model comprising a first reference to a shared object, wherein the shared object specifies the first set of data to be used in the first visualization;

sending the first query to a computing system;

in response to the first query, receiving from the computing system the first set of data, wherein the first set of data is included in a data model managed by the computing system;

generating the first visualization based on the first set of data;

generating a second query for a second set of data corresponding to a second visualization based on a second query model associated with the second visualization, the second query model comprising a second reference to the shared object, wherein the shared object further specifies the second set of data to be used in the second visualization;

sending the second query to the computing system;

in response to the second query, receiving from the computing system the second set of data included in the data model managed by the computing system; and

generating the second visualization based on the second set of data,

wherein the first query model represents a first query for data for a first associated visualization and comprises one or more dimensions corresponding to dimensions in the first associated visualization, wherein the second query model represents a second query for data for a second associated visualization and comprises one or more dimensions corresponding to dimensions in the second associated visualization, and wherein the first query model and the second query model are different query models associated with different visualizations.

2. The non-transitory machine-readable medium of claim 1 , wherein generating the first query comprises transforming the first query model into a runtime version of the first query model.

3. The non-transitory machine-readable medium of claim 2 , wherein transforming the first query model into the runtime version of the first query model comprises:

based on the first reference, retrieving the shared object; and

generating a set of transient objects based on the shared object, wherein sending the first query to the computing system comprises sending the runtime version of the first query model to the computing system.

4. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises sets of instructions for:

providing a graphical user interface (GUI) for defining shared objects; and

receiving, through the GUI, a definition of the shared object.

5. The non-transitory machine-readable medium of claim 1 , wherein the program further comprises sets of instructions for serializing the first query model for storage by converting the first query model into a format configured to be stored in a storage.

6. The non-transitory machine-readable medium of claim 5 , wherein converting the first query model comprises determining a set of identifiers (IDs) for collectively identifying the shared object model and including the set of IDs in the first query model formatted according to the format.

7. The non-transitory machine-readable medium of claim 1 , wherein the shared object is a calculation object configured to derive data based on data included in the data model.

8. A method comprising:

generating a first query for a first set of data corresponding to a first visualization based on a first query model associated with the first visualization, the first query model comprising a first reference to a shared object, wherein the shared object specifies the first set of data to be used in the first visualization;

sending the first query to a computing system;

in response to the first query, receiving from the computing system the first set of data, wherein the first set of data is included in a data model managed by the computing system;

generating the first visualization based on the first set of data;

generating a second query for a second set of data corresponding to a second visualization based on a second query model associated with the second visualization, the second query model comprising a second reference to the shared object, wherein the shared object further specifies the second set of data to be used in the second visualization;

sending the second query to the computing system;

in response to the second query, receiving from the computing system the second set of data included in the data model managed by the computing system; and

generating the second visualization based on the second set of data,

wherein the first query model represents a first query for data for a first associated visualization and comprises one or more dimensions corresponding to dimensions in the first associated visualization, wherein the second query model represents a second query for data for a second associated visualization and comprises one or more dimensions corresponding to dimensions in the second associated visualization, and wherein the first query model and the second query model are different query models associated with different visualizations.

9. The method of claim 8 , wherein generating the first query comprises transforming the first query model into a runtime version of the first query model.

10. The method of claim 9 , wherein transforming the first query model into the runtime version of the first query model comprises:

based on the first reference, retrieving the shared object; and

generating a set of transient objects based on the shared object, wherein sending the first query to the computing system comprises sending the runtime version of the first query model to the computing system.

11. The method of claim 8 further comprising:

providing a graphical user interface (GUI) for defining shared objects; and

receiving, through the GUI, a definition of the shared object.

12. The method of claim 8 further comprising serializing the first query model for storage by converting the first query model into a format configured to be stored in a storage.

13. The method of claim 12 , wherein converting the first query model comprises determining a set of identifiers (IDs) for collectively identifying the shared object model and including the set of IDs in the first query model formatted according to the format.

14. The method of claim 8 , wherein the shared object is a calculation object configured to derive data based on data included in the data model.

15. A system comprising:

a set of processing units; and

a non-transitory machine-readable medium storing instructions that when executed by at least one processing unit in the set of processing units cause the at least one processing unit to:

generate a first query for a first set of data corresponding to a first visualization based on a first query model associated with the first visualization, the first query model comprising a first reference to a shared object, wherein the shared object specifies the first set of data to be used in the first visualization;

send the first query to a computing system;

in response to the first query, receive from the computing system the first set of data, wherein the first set of data is included in a data model managed by the computing system;

generate the first visualization based on the first set of data;

generate a second query for a second set of data corresponding to a second visualization based on a second query model associated with the second visualization, the second query model comprising a second reference to the shared object, wherein the shared object further specifies the second set of data to be used in the second visualization;

send the second query to the computing system;

in response to the second query, receive from the computing system the second set of data included in the data model managed by the computing system; and

generate the second visualization based on the second set of data,

wherein the first query model represents a first query for data for a first associated visualization and comprises one or more dimensions corresponding to dimensions in the first associated visualization, wherein the second query model represents a second query for data for a second associated visualization and comprises one or more dimensions corresponding to dimensions in the second associated visualization, and wherein the first query model and the second query model are different query models associated with different visualizations.

16. The system of claim 15 , wherein generating the first query comprises transforming the first query model into a runtime version of the first query model.

17. The system of claim 16 , wherein transforming the first query model into the runtime version of the first query model comprises:

based on the first reference, retrieving the shared object; and

generating a set of transient objects based on the shared object, wherein sending the first query to the computing system comprises sending the runtime version of the first query model to the computing system.

18. The system of claim 15 , wherein the instructions further cause the at least one processing unit to:

provide a graphical user interface (GUI) for defining shared objects; and

receive, through the GUI, a definition of the shared object.

19. The system of claim 15 , wherein the instructions further cause the at least one processing unit to serialize the first query model for storage by converting the first query model into a format configured to be stored in a storage.

20. The system of claim 19 , wherein converting the first query model comprises determining a set of identifiers (IDs) for collectively identifying the shared object model and including the set of IDs in the first query model formatted according to the format.

Assignments (2)
CHANGE OF NAME Recorded Jan 26, 2026
From: BUSINESS OBJECTS SOFTWARE LIMITED
To: SAP IRELAND LIMITED
Reel/Frame 074510/0354 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 17, 2021
From: WONG, JUSTIN; LIU, RUI; CHUAHUICO, CLARENCE; KADARUSMAN, SEMUEL; JOVANOVIC, VELJKO
To: BUSINESS OBJECTS SOFTWARE LTD
Reel/Frame 058144/0420 →
Continuity (2)
Provisional Application 63237927 · Aug 27, 2021
Related Publication 20230062012A1 · Mar 2, 2023