System and method for management of an automatic OLAP report broadcast system

• US 6,567,796 B1
• Filed: 07/01/1999
• Issued: 05/20/2003
• Est. Priority Date: 03/23/1999
• Status: Expired due to Term

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Trenkamp, Robert G., Wilding, Peter G., Yost, Kyle N.
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): NGUYEN, TAM V
• Application Number:
  US09/345,440
• Time in Patent Office: 1,419 Days
• Field of Search: 707/2, 707/3, 707/5, 707/6
• US Class Current: 1/1
• CPC Class Codes: H04L 41/5054 Automatic deployment of services triggered by the service manager, e.g. service implementation by automatic configuration of network components
• CPC Class Codes: H04L 41/5064 Customer relationship management
• CPC Class Codes: H04L 41/5067 Customer-centric QoS measurements
• CPC Class Codes: H04L 43/00 Arrangements for monitoring or testing data switching networks
• CPC Class Codes: H04L 43/06 Generation of reports
• CPC Class Codes: H04L 43/0817 by checking functioning
• CPC Class Codes: H04L 43/091 Measuring contribution of individual network components to actual service level
• CPC Class Codes: H04L 43/16 Threshold monitoring
• CPC Class Codes: H04L 51/066 Format adaptation, e.g. format conversion or compression
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A system, method and processor medium that manages automatic generation of output from an on-line analytical processing system. Scheduled services are processed in an on-line analytical processing system and output from the OLAP system is then automatically forwarded to one or more subscriber output devices specified for that service. The system manages the operation of the service processing system to increase throughput, increase speed, and improve the administrator control over the processing. The system may maintain dynamic recipient lists that are resolved by system. The system enables administrator control over processing by enabling administrators to view all services and all subscribers of the system, by maintaining an address book containing entries for subscribers of the service and enables a system user to view the contents of the address book, and by scheduling processing of services. The system governs the volume of services being processed, the number of subscribers to a particular service, and the number of output devices to which a service may be broadcast.

Claims

1. A system for managing automatic generation of output from an on-line analytical processing system, comprising:

service processing means for processing at least one scheduled service in an on-line analytical processing system;

output forwarding means for automatically forwarding output from the services to one or more subscriber output devices specified for that service;

processing management means for managing the operation of the service processing means; and

wherein the processing management means manages a plurality of operations of the service processing means automatically based on predetermined performance criteria specified by an administrative user.

2. The of claim 1 wherein the OLAP system comprises a relational OLAP system.

3. The system of claim 1 wherein the processing management means maintains dynamic recipient lists and wherein the service processing means and processing management means resolve dynamic recipient lists to generate a list of subscriber output devices to receive the output.

4. The system of claim 1 wherein the processing management means monitors performance of the service processing means and the output forwarding means to increase throughput and processing speed by reducing duplicate reports.

5. The system of claim 1 wherein the processing management means further comprises an administrative view module that enables a system administrator to view any service record and any subscriber record.

6. The system of claim 1 wherein the processing management means maintains an address book containing entries for subscribers of the service and enables a system user to view the contents of the address book.

7. The system of claim 1 wherein the processing management means comprises a service module that schedules services for processing by the service processing means.

8. The system of claim 1 wherein the processing management means comprises a governing module that governs the volume of services being processed by the service processing means.

9. The system of claim 1 wherein the processing management means comprises a governing module that governs the number of subscribers to a particular service.

10. The system of claim 1 wherein the processing management means comprises a governing module that governs the number of output devices to which a service may be broadcast.

11. A method for managing a system that automatically generates output from an on-line analytical processing system comprising the steps of:

processing at least one scheduled service in an on-line analytical processing system;

automatically forwarding output from the services to one or more subscriber output devices specified for that service;

enabling administrator control over the processing and automatically forwarding steps;

managing the processing step automatically based on predetermined performance criteria specified by an administrative user.

12. The method of claim 11 wherein the OLAP system comprises a relational OLAP system.

13. The method of claim 11 further comprising the steps of maintaining dynamic recipient lists and resolving the dynamic recipient lists to generate a list of subscriber output devices to receive the output.

14. The method of claim 11 further comprising the steps of monitoring performance of the service processing means and the output forwarding means to increase throughput and processing speed by reducing duplicate reports.

15. The method of claim 11 wherein the enabling step further comprises enabling administrators to view any service record and any subscriber record.

16. The method of claim 11 further comprising the step of scheduling services processing by the service processing means.

17. The method of claim 11 further comprising the step of governing the volume of services being processed by the service processing means, the number of subscribers to a particular service, or the number of output devices to which a service may be broadcast.

18. A processor usable medium having code embodied therein for managing an automatic output on-line analytical processing system, the code in the processor usable medium comprising:

code for causing a processor to process at least one scheduled service in an on-line analytical processing system;

code for causing a processor to automatically forward output from the services to one or more subscriber output devices specified for that service;

code for causing a processor to enable administrator control over the processing and forwarding of services; and

code for causing a processor to manage the processing step automatically based on predetermined performance criteria specified by an administrative user.