IP Library Granted Patent US 8,473,520
Granted Patent B1
US 8,473,520 · App. 13/340,231 · Granted Jun 25, 2013

Delta measures

Inventors: Ka Chun Tsang (Coquitlam, CA); Seyyed Ali Moosavi (Vancouver, CA); Yu-Hua Chou (Vancouver, CA); Finlay Cannon (Vancouver, CA)
Assignee: Business Objects Software Limited
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,473,520
App. No.
13/340,231
Granted
Jun 25, 2013
Kind
B1
Abstract

A system may include reception of a selection of a set of one or more elements of a data visualization, the set associated with a measure and each of the one or more elements associated with a value of the measure for a respective combination of one or more dimension members, reception of an instruction to create a second set of one or more elements associated with a calculated measure, where a value of the calculated measure for a respective combination is based on two values of the measure for the respective combination, and where a first value of the two values of the measure is associated with a first time and a second value of the two values of the measure is associated with a second time, and automatic generation of a query to produce the value of the calculated measure for each of the combinations.

Claims (81)

1. A method implemented by a computing system in response to execution of program code by a processor of the computing system, the method comprising:

receiving, from a user, a selection of a set of one or more elements of a data visualization, the set associated with a measure and each of the one or more elements associated with a value of the measure for a respective combination of one or more dimension members;

receiving, from the user, an instruction to create a second set of one or more elements associated with a calculated measure, where a value of the calculated measure for a respective combination of one or more dimension members is based on two values of the measure for the respective combination of one or more dimension members, and where a first value of the two values of the measure is associated with a first time and a second value of the two values of the measure is associated with a second time;

in response to the instruction, automatically generating a query to produce a value of the calculated measure for each of the combinations of one or more dimension members; and

presenting the second set of one or more elements including the value of the calculated measure for each of the combinations of one or more dimension members.

2. A method according to claim 1 , the method further comprising:

receiving, from the user, a second instruction to create a third set of one or more elements associated with a second calculated measure, where the second calculated measure for a respective combination of one or more dimension members is based on the first value and the second value;

in response to the second instruction, automatically generating a second query to produce a value of the second calculated measure for each of the combinations of one or more dimension members; and

presenting the third set of one or more elements including the value of the second calculated measure for each of the combinations of one or more dimension members.

3. A method according to claim 2 , the method further comprising:

receiving, from the user, a third instruction to change the second time to a third time;

in response to the third instruction:

automatically generating a third query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

automatically generating a fourth query to produce a second value of the second calculated measure for each of the combinations of one or more dimension members, where the second value of the second calculated measure for a respective combination of one or more dimension members is based on the first value and the third value; and

presenting the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members; and

presenting the third set of one or more elements including the second value of the second calculated measure for each of the combinations of one or more dimension members.

4. A method according to claim 1 , the method further comprising:

receiving, from the user, a second instruction to change the second time to a third time;

in response to the second instruction, automatically generating a second query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

presenting the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members.

5. A method according to claim 1 , wherein automatically generating the query comprises:

generating a multi-dimensional language query; and

providing the multi-dimensional language query to a multi-dimensional data source.

6. A method according to claim 1 , wherein automatically generating the query comprises:

generating the query specifying the measure, the first time and the second time; and

providing the query to a data source.

7. A non-transitory medium storing processor-executable program code, the program code executable by a processor of a computing device to:

receive, from a user, a selection of a set of one or more elements of a data visualization, the set associated with a measure and each of the one or more elements associated with a value of the measure for a respective combination of one or more dimension members;

receive, from the user, an instruction to create a second set of one or more elements associated with a calculated measure, where a value of the calculated measure for a respective combination of one or more dimension members is based on two values of the measure for the respective combination of one or more dimension members, and where a first value of the two values of the measure is associated with a first time and a second value of the two values of the measure is associated with a second time;

in response to the instruction, automatically generate a query to produce a value of the calculated measure for each of the combinations of one or more dimension members; and

present the second set of one or more elements including the value of the calculated measure for each of the combinations of one or more dimension members.

8. A medium according to claim 7 , the program code further executable by a processor of a computing device to:

receive, from the user, a second instruction to create a third set of one or more elements associated with a second calculated measure, where the second calculated measure for a respective combination of one or more dimension members is based on the first value and the second value;

in response to the second instruction, automatically generate a second query to produce a value of the second calculated measure for each of the combinations of one or more dimension members; and

present the third set of one or more elements including the value of the second calculated measure for each of the combinations of one or more dimension members.

9. A medium according to claim 8 , the program code further executable by a processor of a computing device to:

receive, from the user, a third instruction to change the second time to a third time;

in response to the third instruction:

automatically generate a third query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

automatically generate a fourth query to produce a second value of the second calculated measure for each of the combinations of one or more dimension members, where the second value of the second calculated measure for a respective combination of one or more dimension members is based on the first value and the third value; and

present the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members; and

present the third set of one or more elements including the second value of the second calculated measure for each of the combinations of one or more dimension members.

10. A medium according to claim 7 , the program code further executable by a processor of a computing device to:

receive, from the user, a second instruction to change the second time to a third time;

in response to the second instruction, automatically generate a second query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

present the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members.

11. A medium according to claim 7 , wherein automatic generation of the query comprises:

generation of a multi-dimensional language query; and

provision of the multi-dimensional language query to a multi-dimensional data source.

12. A medium according to claim 7 , wherein automatic generation of the query comprises:

generation of the query specifying the measure, the first time and the second time; and

provision of the query to a data source.

13. A system comprising:

a computing device comprising:

a memory storing processor-executable program code; and

a processor to execute the processor-executable program code in order to cause the computing device to:

receive, from a user, a selection of a set of one or more elements of a data visualization, the set associated with a measure and each of the one or more elements associated with a value of the measure for a respective combination of one or more dimension members;

receive, from the user, an instruction to create a second set of one or more elements associated with a calculated measure, where a value of the calculated measure for a respective combination of one or more dimension members is based on two values of the measure for the respective combination of one or more dimension members, and where a first value of the two values of the measure is associated with a first time and a second value of the two values of the measure is associated with a second time;

in response to the instruction, automatically generate a query to produce a value of the calculated measure for each of the combinations of one or more dimension members; and

present the second set of one or more elements including the value of the calculated measure for each of the combinations of one or more dimension members.

14. A system according to claim 13 , the processor to further execute the processor-executable program code in order to cause the computing device to:

receive, from the user, a second instruction to create a third set of one or more elements associated with a second calculated measure, where the second calculated measure for a respective combination of one or more dimension members is based on the first value and the second value;

in response to the second instruction, automatically generate a second query to produce a value of the second calculated measure for each of the combinations of one or more dimension members; and

present the third set of one or more elements including the value of the second calculated measure for each of the combinations of one or more dimension members.

15. A system according to claim 14 , the processor to further execute the processor-executable program code in order to cause the computing device to:

receive, from the user, a third instruction to change the second time to a third time;

in response to the third instruction:

automatically generate a third query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

automatically generate a fourth query to produce a second value of the second calculated measure for each of the combinations of one or more dimension members, where the second value of the second calculated measure for a respective combination of one or more dimension members is based on the first value and the third value; and

present the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members; and

present the third set of one or more elements including the second value of the second calculated measure for each of the combinations of one or more dimension members.

16. A system according to claim 13 , the processor to further execute the processor-executable program code in order to cause the computing device to:

receive, from the user, a second instruction to change the second time to a third time;

in response to the second instruction, automatically generate a second query to produce a second value of the calculated measure for each of the combinations of one or more dimension members, where the second value of the calculated measure for a respective combination of one or more dimension members is based on the first value of the measure for the respective combination of one or more dimension members and on a third value of the measure for the respective combination of one or more dimension members, and where the third value is associated with the third time; and

present the second set of one or more elements including the second value of the calculated measure for each of the combinations of one or more dimension members.

17. A system according to claim 13 , wherein automatic generation of the query comprises:

generation of a multi-dimensional language query; and

provision of the multi-dimensional language query to a multi-dimensional data source.

18. A system according to claim 13 , wherein automatic generation of the query comprises:

generation of the query specifying the measure, the first time and the second time; and

provision of the query to a data source.

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 Mar 7, 2012
From: TSANG, KA CHUN; MOOSAVI, SEYYED ALI; CHOU, YU-HUA; CANNON, FINLAY
To: BUSINESS OBJECTS SOFTWARE LIMITED
Reel/Frame 027819/0299 →