Report system and method using prompt objects

• US 7,861,161 B1
• Filed: 06/19/2001
• Issued: 12/28/2010
• Est. Priority Date: 06/19/2001
• Status: Active Grant

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Sherwood, David B., Carranza, Eduardo, Everhart, L. Douglas, Hurwood, William, Warikoo, Abhimanyu, Bedell, Jeffrey A., Li, Benjamin Z., Ramachandran, Ramkumar, Trundle, Stephen S.
• Primary Examiner(s): HUYNH, CONG LAC T
• Application Number:
  US09/883,502
• Time in Patent Office: 3,479 Days
• Field of Search: 715/530, 715/500, 715/531, 715/808, 715/809, 715/200, 715/255, 715/800, 707/4, 345/808, 345/809
• US Class Current: 715/255
• CPC Class Codes: G06F 16/838 Presentation of query results
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

An report system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system (e.g., 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.

Claims

1. A prompt object on a computer-readable medium used in creating a report to be executed in a reporting system, wherein the report may specify a prompt object as a property of the report, the prompt object comprising:

a question to be asked of a user;

a prompt type; and

at least one validation property;

wherein the prompt object is used in creating a report to be executed in a reporting system, wherein the report may specify a prompt object as a property of the report, and wherein the prompt object is an object separate from the report such that the prompt object may be used more than once in a single report or may be used in more than one report.

2. The prompt object of claim 1 wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type.

3. The prompt object of claim 1 further comprising a default answer to the question.

4. The prompt object of claim 1 further comprising a meaning that, upon request by a responder to the prompt, provides an explanation of the question.

5. The prompt object of claim 1 further comprising a reuse value that indicates whether an answer provided from a previous instance of that prompt object, a default value or a new value is to be used for an answer to the question in the prompt object.

6. A computer-implemented 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 prompt object;

wherein the prompt object comprises;

a question to be asked of a user;

a prompt type; and

at least one validation property, wherein the prompt object is an object separate from the report and separate from the one or more templates or filters such that the prompt object may be used more than once in a single report or may be used in more than one report.

7. The method of claim 6 wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type.

8. The method of claim 6 wherein the prompt object further comprises a default answer to the question.

9. The method of claim 6 wherein the prompt object further comprises a meaning that, upon request by a responder to the prompt, provides an explanation of the question.

10. The method of claim 6 wherein the prompt object further comprises a reuse value that indicates whether an answer provided from a previous instance of that prompt object, a default value or a new value is to be used for an answer to the question in the prompt object.

11. The method of claim 6 further comprising the step of specifying a single prompt object for a plurality of properties in the report and wherein upon report execution, the question receives only one answer that is provided to a each property properties for which the prompt object was specified.

12. The method of claim 6 further comprising specifying at most one prompt object for a template or filter property.

13. The method of claim 6 wherein the template comprises a set of templates properties and the filter comprises a set of filter properties and wherein every template and filter property may be specified as a prompt object.

14. 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 prompt object;

wherein the prompt object comprises;

a question to be asked of a user;

a prompt type; and

at least one validation property, wherein the prompt object is an object separate from the report such that the prompt object may be used more than once in a single report or may be used in more than one report.

15. The medium of claim 14 wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type.

16. The medium of claim 14 wherein the prompt object further comprises a default answer to the question.

17. The medium of claim 14 wherein the prompt object further comprises a meaning that, upon request by a responder to the prompt, provides an explanation of the question.

18. The medium of claim 14 wherein the prompt object further comprises a reuse value that indicates whether an answer provided from a previous instance of that prompt object, a default value or a new value is to be used for an answer to the question in the prompt object.

19. The medium of claim 14 further comprising code for enabling a user to specify a single prompt object 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 a each property properties for which the prompt object was specified.

20. The medium of claim 14 wherein the template comprises a set of templates properties and the filter comprises a set of filter properties and further comprising code for causing a processor to enable a user to specify a prompt object fear each template and filter property selected.

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

report selection means embodied on a computer-readable medium that enables a report creator to define one or more of a template, filter, or properties thereof with a prompt object;

wherein the prompt object comprises;

a question to be asked of a user;

a prompt type; and

at least one validation property, wherein the prompt object is an object separate from the report such that the prompt object may be used more than once in a single report or may be used in more than one report.

22. The system of claim 21 wherein at least one validation property comprises verification that the answer provided to the question is of the specified prompt type.

23. The system of claim 21 wherein the prompt object further comprises a default answer to the question.

24. The system of claim 21 wherein the prompt object further comprises a meaning that, upon request by a responder to the prompt, provides an explanation of the question.

25. The system of claim 21 wherein the prompt object further comprises a reuse value that indicates whether an answer provided from a previous instance of that prompt object, a default value or a new value is to be used for an answer to the question in the prompt object.

26. The system of claim 21 wherein the report selection means enables a report creator to specify a single prompt object for a plurality of properties in the report and wherein upon report execution, the question receives only one answer that is provided to a each property properties for which the prompt object was specified.

27. The system of claim 21 wherein the report selection means enables a report creator to specify at most one prompt object for a template or filter property.

28. The system of claim 21 wherein the template comprises a set of templates properties and the filter comprises a set of filter properties and wherein every template and filter property may be specified as a prompt object.