Report system and method using context-sensitive prompt objects

• US 20060026122A1
• Filed: 07/29/2005
• Published: 02/02/2006
• Est. Priority Date: 06/19/2001
• Status: Active Grant

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Richardson, Chris, Hurwood, William, Cappiello, Scott
• Granted Patent: US 7,925,616 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/838 Presentation of query results
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A reporting system that incorporates a context sensitive prompt object in a report definition to enable questions to be answered automatically by the reporting system (e.g., decision support system, business intelligence and OLAP) at report execution time. The context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports. The answer is defined at least in part by a contextual feature of the report execution.

Claims

1. A context sensitive prompt object used in creating a report to be executed in a reporting system containing a computer processor, the context sensitive prompt object comprising:

a question to be answered automatically during execution of a report, wherein an answer to the question is defined at least in part by a contextual feature of the report execution,

wherein the report specifies the context sensitive prompt object as a property of the report, and wherein the context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports.

2. The context sensitive prompt object of claim 1, wherein the answer is based on the identity of a user executing the report.

3. The context sensitive prompt object of claim 2, wherein the report is executed on a database, and wherein the validation property comprises security information for each of a plurality of users that specifies each user'"'"'s access to information in the database.

4. The context sensitive prompt object of claim 2, wherein the answer is different for a plurality of different users.

5. The context sensitive prompt object of claim 4, wherein a single report that is executed using the context sensitive prompt object returns different results for different users.

6. The context sensitive prompt object of claim 2, wherein the answer is determined based on a user id entered at logon.

7. The system of claim 1, wherein the context sensitive prompt object is part of a security filter.

8. The context sensitive prompt object of claim 1, wherein the answer is defined by a time, wherein the time comprises at least one of:

the time at which a user executing the report initiated report execution, the time at which the answer is resolved, the time at which the report is executed, and the time at which the report was last executed.

9. The context sensitive prompt object of claim 1, wherein the answer is defined by the identity of the computer requesting execution of the report.

10. The context sensitive prompt object of claim 1, wherein the answer is based on a location, wherein the location comprises at least one of:

a location of a user computer requesting execution of the report, a location associated with a user executing the report, and a location of a merchant entity associated with a user or computer executing the report.

11. The context sensitive prompt object of claim 1, wherein the answer is based on a language that is identified based on user input.

12. The context sensitive prompt object of claim 1, wherein the context sensitive prompt object is exposed in a user interface in at least one of an object browser, special button, and function editor.

13. The context sensitive prompt object of claim 1, wherein the context sensitive prompt object further comprises a prompt type and wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type.

14. The context sensitive prompt object of claim 1, wherein a single context sensitive prompt object is specified for a plurality of properties in a report definition object and wherein upon report execution, the question receives only one answer that is provided to each of the properties for which the prompt object was specified.

15. The context sensitive prompt object of claim 1, wherein the context sensitive prompt object may be used more than once during a single execution of a report.

16. The context sensitive prompt object of claim 1, wherein the answer comprises one or more of the following:

name of a user;

a password entered at logon;

time of logon;

time of execution of report;

time of first report execution; and

time at which a database related to a report was last updated.

17. The context sensitive prompt object of claim 1, wherein the answer comprises one or more of the following:

an IP address of a report-initiating computer;

a phone number of a report-initiating computer; and

a language associated with the user.

18. A context sensitive prompt object used in creating a report to be executed in a reporting system containing a computer processor, the context sensitive prompt object comprising at least one validation property.

19. A method of creating a report to be executed on a reporting system, the method comprising the steps of:

selecting a template with one or more template properties;

selecting a filter with one or more filter properties; and

specifying one or more of the template or filter properties with a context sensitive prompt object,

wherein the context sensitive prompt object comprises a question to be answered automatically during execution of a report, wherein an answer to the question is defined at least in part by a contextual feature of the report execution, wherein the report specifies the context sensitive prompt object as a property of the report, and wherein the context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports.

20. A system for a report to be executed on a reporting system comprising:

report selection means that enable a report creator to define one or more of a template, filter, or properties thereof with a context sensitive prompt object,

wherein the context sensitive prompt object comprises a question to be answered automatically during execution of a report, wherein an answer to the question is defined at least in part by a contextual feature of the report execution, wherein the report specifies the context sensitive prompt object as a property of the report, and wherein the context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports.

21. A processor-readable medium comprising code for execution by a processor to create a report to be executed on a reporting system, the medium comprising:

code for causing a processor to enable a user to select a template with one or more template properties;

code for causing a processor to enable a user to select a filter with one or more filter properties; and

code for causing a processor to enable a user to specify one or more of the template or filter properties with a context sensitive prompt object;

wherein the context sensitive prompt object comprises;

a question to be answered automatically during execution of a report, wherein an answer to the question is defined at least in part by a contextual feature of the report execution, wherein the report specifies the context sensitive prompt object as a property of the report, and wherein the context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports.