Report system and method using prompt in prompt objects

• US 7,302,639 B1
• Filed: 06/19/2001
• Issued: 11/27/2007
• Est. Priority Date: 06/19/2001
• Status: Expired due to Fees

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Hurwood, William, Warikoo, Abhimanyu, Li, Benjamin Z., Everhart, L. Douglas
• Primary Examiner(s): Hong; Stephen
• Assistant Examiner(s): Stork; Kyle R.
• Application Number:
  US09/883,500
• Time in Patent Office: 2,352 Days
• Field of Search: 715/530, 715/517, 715/513, 715/523
• US Class Current: 707/603
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system, decision support system, business intelligence and OLAP report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A prompt object may also contain another prompt object nested within it, in which the answer to an inner prompt object is used by the system to validate the answer to an outer prompt object.

Claims

1. A reporting system including at least one processor for creating a report, wherein a report definition specifies one or more prompt objects as properties of the report definition, comprising:

an inner prompt object comprising a first question to be asked of a user and at least one validation property;

an outer prompt object comprising a second question to be asked of a user and at least one validation property;

wherein the inner prompt object is nested within the outer prompt object, and wherein each of the inner and outer prompt objects is an object separate in object oriented programming terms from the report definition in which it is contained such that each of the inner and outer prompt objects is useable more than once in a single report definition or is useable in more than one report definition and answers to the prompt object are storable in association with the prompt object for later retrieval; and

wherein execution of the report definition creates a report, wherein the report definition contains instructions for creating the report.

2. The system according to claim 1, further comprising:

a first answer provided by a user to the first question of the inner prompt object; and

a second answer provided by a user to the second question of the outer prompt object.

3. The system according to claim 2, wherein the first answer to the first question of the inner prompt object serves as a validation property to the second answer to the second question of the outer prompt object.

4. The system according to claim 1, wherein the inner and outer prompt objects are embedded in a draft prompt.

5. The system according to claim 1 wherein the inner prompt is used as part of a definition of a plurality of outer prompts.

6. A method of creating a report to be executed on a reporting system 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 an inner prompt object and an outer prompt object;

wherein the inner prompt object comprises a first question to be asked of a user and at least one validation property;

further wherein the outer prompt object comprises a second question to be asked of a user and at least one validation property; and

further wherein each of the inner and outer prompt objects is an object separate in object oriented programming terms from the report in which it is contained such that each of the inner and outer prompt objects is useable more than once in a single report or is useable in more than one report and answers to the prompt object are storable in association with the prompt object for later retrieval.

7. The method according to claim 6, further comprising the steps of:

providing a first answer to the first question of the inner prompt object; and

providing a second answer to the second question of the outer prompt object.

8. The method according to claim 7, wherein the first answer to the first question of the inner prompt object serves as a validation property to the second answer of the second question of the outer prompt object.

9. The method according to claim 6, wherein the inner and outer prompt objects are embedded in a draft prompt.

10. The method according to claim 6 wherein the inner prompt is used as part of a definition of a plurality of outer prompts.

11. 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 an inner prompt object and an outer prompt object;

wherein the inner prompt object comprises a first question to be asked of a user and at least one validation property;

further wherein the outer prompt object comprises a second question to be asked of a user and at least one validation property; and

further wherein each of the inner and outer prompt objects is an object separate in object oriented programming terms from the report in which it is contained such that each of the inner and outer prompt objects is useable more than once in a single report or is useable in more than one report and answers to the prompt object are storable in association with the prompt object for later retrieval.

12. The medium according to claim 11, further comprising:

a first answer provided by a user to the first question of the inner prompt object; and

a second answer provided by a user to the second question of the outer prompt object.

13. The medium according to claim 12, wherein the first answer to the first question of the inner prompt object serves as a validation property to the second answer to the second question of the outer prompt object.

14. The medium according to claim 11, wherein the inner and outer prompt objects are embedded in a draft prompt.

15. The medium according to claim 11 wherein the inner prompt is used as part of a definition of a plurality of outer prompts.

16. A nested prompt object in a computer-readable medium, wherein the nested prompt object is used in creating a report definition to be executed in a reporting system, wherein the report definition specifies a prompt object as a property of the report, the nested prompt object comprising an outer prompt object that comprises:

a question to be asked of a user;

at least one validation property;

wherein at least one of the question and the at least one validation property is defined by an inner prompt object; and

further wherein each of the inner and outer prompt objects is an object separate in object oriented programming terms from the report definition in which it is contained such that each of the inner and outer prompt objects is useable more than once in a single report definition or is useable in more than one report definition and answers to the prompt object are storable in association with the prompt object for later retrieval; and

further wherein execution of the report definition creates a report, wherein the report definition contains instructions for creating the report.

17. The nested prompt object of claim 16, further comprising:

a first answer provided by a user to the first question of the inner prompt object; and

a second answer provided by a user to the second question of the outer prompt object.

18. The nested prompt object of claim 17, wherein the first answer to the first question of the inner prompt object serves as a validation property to the second answer to the second question of the outer prompt object.

19. The nested prompt object of claim 16, wherein the inner and outer prompt objects are embedded in a draft prompt.

20. The nested prompt object of claim 16, wherein the inner prompt is used as part of a definition of a plurality of outer prompts.