Report system and method using context-sensitive prompt objects

• US 7,925,616 B2
• Filed: 07/29/2005
• Issued: 04/12/2011
• Est. Priority Date: 06/19/2001
• Status: Expired due to Fees

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Richardson, Chris, Cappiello, Scott, Hurwood, William
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Nguyen; Kim T
• Application Number:
  US11/192,103
• Publication Number:
  US 20060026122A1
• Time in Patent Office: 2,083 Days
• Field of Search: 707/600, 707/603
• US Class Current: 707/600
• 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 stored in a computing system and used in creating a report to be executed in a reporting system using a computer processor, the context sensitive prompt object comprising:

a context sensitive prompt object configured to create a report in an On-Line Analytical Processing (OLAP) decision support system (DSS), wherein the context sensitive prompt object is part of a security filter;

a question to be answered automatically during execution of the report;

an answer to the question being defined at least in part by a contextual feature of the report execution;

a prompt type wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type; and

at least one attribute or dimension indicating how the prompt object is to be processed, wherein the at least one attribute or dimension provides browse path information to enable selection of one or more elements to be presented in the report,

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 a validation property of the context sensitive prompt object 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 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.

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

9. 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.

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

11. 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.

12. 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.

13. 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.

14. 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.

15. 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.

16. A context sensitive prompt object stored in a computing system 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; and

a context sensitive prompt object, wherein the context sensitive prompt object comprises;

a question to be answered automatically during execution of a report in an On-Line Analytical Processing (OLAP) decision support system (DSS), wherein the context sensitive prompt object is part of a security filter;

an answer to the question is defined at least in part by a contextual feature of the report execution, and wherein the at least one validation property is utilized to validate the answer;

a prompt type wherein the at least one validation property comprises verification that the answer provided to the question is of the specified prompt type; and

at least one attribute or dimension indicating how the prompt object is to be processed, wherein the at least one attribute or dimension provides browse path information to enable selection of one or more elements to be presented in the report,

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.

17. 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 comprising

a question to be answered automatically during execution of a report in an On-Line Analytical Processing (OLAP) decision support system (DSS), an answer to the question being defined at least in part by a contextual feature of the report execution, a prompt type wherein the at least one validation property comprises verification that the answer provided to the question is of the specified prompt type, and at least one attribute or dimension indicating how the prompt object is to be processed,

wherein the at least one attribute or dimension provides browse path information to enable selection of one or more elements to be presented in the report, 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.

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

a processor;

a report creator configured to create a report in an On-Line Analytical Processing (OLAP) decision support system (DSS);

a report selector that enables the 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, an answer to the question being defined at least in part by a contextual feature of the report execution, a prompt type wherein the at least one validation property comprises verification that the answer provided to the question is of the specified prompt type, and at least one attribute or dimension indicating how the prompt object is to be processed, wherein the at least one attribute or dimension provides browse path information to enable selection of one or more elements to be presented in the report, 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.

19. 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 in an On-Line Analytical Processing (OLAP) decision support system (DSS), an answer to the question being defined at least in part by a contextual feature of the report execution, a prompt type wherein the at least one validation property comprises verification that the answer provided to the question is of the specified prompt type, and at least one attribute or dimension indicating how the prompt object is to be processed, wherein the at least one attribute or dimension provides browse path information to enable selection of one or more elements to be presented in the report, 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.