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

• US 8,321,411 B2
• Filed: 02/11/2008
• Issued: 11/27/2012
• Est. Priority Date: 03/23/1999
• Status: Expired due to Fees

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Yost, Kyle, Saylor, Michael, Wilding, Peter, Trenkamp, Robert
• Primary Examiner(s): VU, BAI DUC
• Application Number:
  US12/029,004
• Publication Number:
  US 20080294713A1
• Time in Patent Office: 1,751 Days
• Field of Search: None
• US Class Current: 707/732
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• 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 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/16 Threshold monitoring
• CPC Class Codes: H04L 51/066 Format adaptation, e.g. format conversion or compression

Abstract

A system, method and processor medium that manages automatic generation of output from an on-line analytical processing (OLAP) system. Scheduled services are processed in an OLAP 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 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 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 method of managing a system that automatically generates output from an on-line analytical processing system, the method comprising:

creating a service to be processed via the on-line analytical processing system according to a schedule;

receiving from a subscriber to the service, during a subscription process, a specified output device to which service output is to be delivered, and specified personalization criteria for personalizing service output;

creating an address book entry for the subscriber in an address book, the address book entry including an address associated with the specified output device, and one or more personalization filters based on the specified personalization criteria;

processing the service via the on-line analytical processing system according to the schedule to generate service output, wherein the service comprises at least one query to be performed against the on-line analytical processing system;

personalizing the service output for the subscriber via the one or more personalization filters included in the address book entry for the subscriber;

forwarding personalized service output to the specified output device of the subscriber; and

managing the processing of the service based on predetermined performance criteria specified by an administrator.

2. The method of claim 1, wherein the on-line analytical processing system comprises a relational on-line analytical processing system.

3. The method of claim 1, further comprising:

enabling the administrator to edit the address book entry for the subscriber.

4. The method of claim 1, further comprising:

monitoring the service processing and the forwarding steps to increase throughput and processing speed.

5. The method of claim 1, further comprising:

enabling the administrator to view any service record.

6. The method of claim 1, wherein the service output comprises one or more reports.

7. The method of claim 1, wherein the service output comprises multiple reports, and wherein the address book entry for the subscriber includes multiple personalization filters, the method further comprising:

applying a different personalization filter to each report.

8. The method of claim 1, wherein the service output comprises multiple reports, the method further comprising:

applying the same personalization filter to each of the multiple reports.

9. A system for managing automatic generation of output from an on-line analytical processing system, the system including one or more computer devices configured to:

create a service to be processed via the on-line analytical processing system according to a schedule;

receive from a subscriber to the service a specified output device to which service output is to be delivered, and specified personalization criteria for personalizing service output;

create an address book entry for the subscriber in an address book, the address book entry including an address associated with the specified output device, and one or more personalization filters based on the specified personalization criteria;

process the service via the on-line analytical processing system according to the schedule to generate service output, wherein the service comprises at least one query to be performed against the on-line analytical processing system;

personalize the service output for the subscriber via the one or more personalization filters included in the address book entry for the subscriber;

forward personalized service output to the specified output device of the subscriber; and

manage the processing of the service based on predetermined performance criteria specified by an administrator.

10. The system of claim 9, wherein the on-line analytical processing system comprises a relational on-line analytical processing system.

11. The system of claim 9, wherein the one or more computer devices are further configured to:

enable the administrator to edit the address book entry for the subscriber.

12. The system of claim 9, wherein the one or more computer devices are further configured to:

increase throughput and processing speed.

13. The system of claim 9, wherein the one or more computer devices are further configured to:

enable the administrator to view any service record.

14. The system of claim 9, wherein the service output comprises one or more reports.

15. The system of claim 9, wherein the service output comprises multiple reports, the address book entry for the subscriber includes multiple personalization filters, and wherein the one or more computer devices are further configured to:

apply a different personalization filter to each report.

16. The system of claim 9, wherein the service output comprises multiple reports, and wherein the one or more computer devices are further configured to:

apply the same personalization filter to each of the multiple reports.