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

• US 7,330,847 B2
• Filed: 01/10/2003
• Issued: 02/12/2008
• Est. Priority Date: 03/23/1999
• Status: Expired due to Fees

• Current Assignee: Reporting Technologies Incorporated (Microstrategy Incorporated)
• Original Assignee: Microstrategy Incorporated
• Inventors: Trenkamp, Robert G., Wilding, Peter G., Yost, Kyle N., Saylor, Michael J.
• Primary Examiner(s): Hwang; Joon Hwan
• Application Number:
  US10/339,579
• Publication Number:
  US 20030101201A1
• Time in Patent Office: 1,859 Days
• Field of Search: 707/3, 707/10
• 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 one or more services processed in an on-line analytical processing system, comprising:

service creating means for enabling an administrative user to create a service to be processed in an on-line analytical processing system and for scheduling the service to be processed according to a schedule;

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

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

output forwarding means for automatically forwarding output from the service to a specified output device of each subscriber subscribed to receive the service; and

processing management means for managing the operation of the service processing means.

2. The system of claim 1, wherein the on-line analytical processing system comprises a relational on-line analytical processing 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 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 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 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 a 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 a number of subscribers to a particular service.

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

11. A method of managing automatic generation of output from one or more services processed in an on-line analytical processing system, comprising:

enabling an administrative user to create a service to be processed in an on-line analytical processing system, and to specify a schedule for processing of the service;

enabling subscribers to subscribe to the service and to select portions of the service to receive as a report;

processing the service in the on-line analytical processing system according to the schedule, the service comprising at least one query to be performed by the on-line analytical processing system;

formulating a separate report for each subscriber based on the portions of the service that subscriber selected;

forwarding output from the service to a specified output device of each subscriber subscribed to receive the service; and

managing the processing of the service based on predetermined performance criteria specified by the administrative user.