System and method for automatic transmission of on-line analytical processing system report output

• US 6,173,310 B1
• Filed: 06/30/1999
• Issued: 01/09/2001
• Est. Priority Date: 03/23/1999
• Status: Expired due to Term

• Current Assignee: Reporting Technologies Incorporated (Microstrategy Incorporated)
• Original Assignee: Microstrategy Incorporated
• Inventors: Trenkamp, Robert G., Wilding, Peter G., Yost, Kyle N.
• Primary Examiner(s): Rinehart, Mark
• Assistant Examiner(s): Cardone, Jason D.
• Application Number:
  US09/343,563
• Time in Patent Office: 559 Days
• Field of Search: 709/200, 709/202, 709/217, 709/218, 709/229, 709/223, 709/225, 709/246, 705/10, 705/14, 705/35, 705/37, 707/1, 707/2, 707/3, 707/4, 707/100, 345/329, 345/330, 345/331
• US Class Current: 709/201
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Abstract

A system for automatically generating output from an on-line analytical processing system based on scheduled services specified by subscribers of the system. The system processes scheduled services in an on-line analytical processing system with each service comprising at least one query to be performed by the on-line analytical processing system. The system then automatically forwards output from the services to one or more subscriber output devices specified for that service. Users may define new services, including the schedule of the services and the type, such as alert services or scheduled services, and may also subscriber to the services provided by the system. If an alert service is processed, the system may forward output only when one or more alert criteria are satisfied. Subscribers may be specified by a dynamic recipient list that is resolved each time the service is processed to determine recipients of the service output. The output devices the system may forward output to may comprise electronic mailbox, facsimile, printer, mobile phone, telephone, PDA or pager.

Claims

1. In a system for automatic generation of output from an on-line analytical processing system, a server system comprising:

service creating means for enabling an administrative user to create a service comprising one or more reports to be processed on an on-line analytical processing system and for scheduling that service to be processed according to a schedule;

service subscription means for enabling a plurality of subscribers to subscribe to the service created by the service creating means and enabling the subscribers to select portions of the service to receive as a report;

service processing means for processing the scheduled service in an on-line analytical processing system, each service comprising at least one query to be performed by the on-line analytical processing system, and formulating a separate report for each subscriber based on the portions of the service that user selected; and

output forwarding means for automatically forwarding output from the services to each subscriber output device subscribed to receive that service.

2. The server system of claim 1 further comprising service definition means for receiving definitions of one or more services.

3. The server system of claim 2 wherein the server definition means comprises service scheduling means for enabling a user to specify the schedule for when a service is to be processed.

4. The server system of claim 3 wherein the service processing means processes services according to the schedule specified in the server definition means for the services.

5. The server system of claim 1 wherein the server system stores one or more services for processing and further comprising subscription means for receiving a list of one or more subscribers to a service.

6. The server system of claim 5 wherein the subscription means enables specifying subscribers to a service by a dynamic recipient list and further comprising dynamic recipient list resolution means for resolving the subscribers in the dynamic recipient list and providing that list of subscribers to the output forwarding means.

7. The server system of claim 1 wherein the service may comprise an alert service and wherein the output forwarding means automatically forwards output from an alert service only when one or more alert criteria are satisfied.

8. The server system of claim 1 wherein the service may comprise a scheduled service and wherein the output forwarding means automatically forwards output from a scheduled service each time the schedule service is processed.

9. The server system of claim 1 wherein the output forwarding means forwards the output to a subscriber output device selected from the group consisting of:

electronic mailbox, facsimile, printer, mobile phone, telephone, PDA, and pager.

10. A method of automatically generating output from an on-line analytical processing system to one or more user devices comprising the steps of:

enabling an administrative user to create a service comprising one or more reports to be processed on an on-line analytical processing system;

storing one or more services to be processed and a schedule for processing one or more of those services;

enabling a plurality of subscribers to subscribe to the service created by the service creating means and enabling the subscribers to select portions of the service to receive as a report;

processing a service in an on-line analytical processing system based on the schedule specified for the service;

generating a separate report for each subscriber based on portions of the service selected by the user; and

automatically forwarding user reports to subscribers according to their request.

11. The method of claim 10 further comprising the step of receiving a schedule for when a service is to be processed.

12. The method of claim 11 wherein the processing step processes services according to the schedule set for a service.

13. The method of claim 10 further comprising the step of receiving a list of subscribers to receive output from a service.

14. The method of claim 13 wherein the step of receiving subscribers comprises the step of receiving a dynamic recipient list for a service and further comprising the step of resolving the dynamic recipient list to determine the subscribers for a service.

15. The method of claim 10 further comprising the step of receiving definitions for one or more services.

16. The method of claim 10 wherein the service may comprise an alert service and wherein the forwarding step involves forwarding output from an alert service only when one or more alert criteria are satisfied.

17. The method of claim 10 wherein the service may comprise a scheduled service and wherein the forwarding step involves forwarding output from a scheduled service each time the schedule service is processed.

18. The method of claim 10 wherein the step of forwarding comprises the step of forwarding output from the service to an output device selected from the group consisting of:

electronic mailbox, facsimile, printer, mobile phone, telephone, PDA, and pager.

19. A processor usable medium having processor readable program code embodied therein for automatically forwarding output from scheduled services processed by an on-line analytical processing system, the computer readable code in the computer usable medium comprising:

processor readable code for causing a processor to enable an administrative user to create a service comprising one or more reports to be processed on an on-line analytical processing system;

processor readable code for causing a processor to enable a plurality of subscribers to subscribe to the service created by the service creating means and enabling the subscribers to select portions of the service to receive as a report;

processor readable code for causing a processor to process at least one scheduled service in an on-line analytical processing system, each service comprising at least one query to be performed by the on-line analytical processing system, and formulating a separate report for each subscriber based on the portions of the service that user selected; and

processor readable code for causing a processor to automatically forwarding output from the services to one or more subscribers of that service to one or more user output devices.