Report system and method using prompt object abstraction

• US 7,945,584 B2
• Filed: 05/24/2010
• Issued: 05/17/2011
• Est. Priority Date: 06/19/2001
• Status: Expired due to Term

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Hurwood, William, Warikoo, Abhimanyu, Bedell, Jeffrey A., Li, Benjamin Z.
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US12/786,208
• Publication Number:
  US 20100299321A1
• Time in Patent Office: 358 Days
• Field of Search: 707/779, 707/803, 707/955, 707/999.1, 707/999.102, 707/999.103, 707/999.104, 707/999.106
• US Class Current: 707/779
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

An reporting system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a 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 collection of answers is built up in a resolution object. 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 resolution object may be created and saved before the execution of a report. The saved resolution object can then be used to answer prompts at the time of the report execution. The resolution object may be created by third parties and transmitted as an XML resolution object, whereupon receipt by the reporting system, the XML resolution object is translated into a reporting system format.

Claims

1. A method of processing a report with one or more prompt objects to be executed in 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, wherein one or more of the template or filter properties has been specified with a prompt object;

selecting a stored resolution object comprising answers to a question of the prompt object; and

processing the report using the stored resolution object to answer prompt object questions.

2. The method according to claim 1, wherein the resolution object is created by an entity different than the entity processing the report.

3. The method according to claim 1, wherein the stored resolution object is used to answer a prompt in a report instance during the execution of a report.

4. The method according to claim 1, wherein an answer from a stored resolution object is used to modify a default answer to a prompt in a report.

5. The method according to claim 3, wherein the resolution object causes the suppression of a prompt.

6. The method according to claim 1, wherein the report is scheduled to execute at a future time.

7. The method according to claim 1, wherein a resolution object converts itself from XML into a format for the reporting system upon receipt by the reporting system from a third party source.

8. 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 selecting a template with one or more template properties, wherein one or more of the template or filter properties has been specified with a prompt object;

code for causing a processor to enable a user to select a stored resolution object comprising answers to a question of the prompt object; and

code for causing a processor to process the report using the stored resolution object to answer prompt object questions.

9. The medium according to claim 8, wherein the resolution object is created by an entity other than the entity processing the report.

10. The medium according to claim 8, wherein the stored resolution object is used to answer a prompt in a report instance during execution of the report.

11. The medium according to claim 10, wherein the resolution object causes the suppression of a prompt.

12. The medium according to claim 8, wherein the report is scheduled to execute at a future time.

13. The medium according to claim 8, wherein a resolution object converts itself from XML into a format for the reporting system upon receipt by the reporting system from a third party source.