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

• US 9,477,740 B1
• Filed: 11/26/2012
• Issued: 10/25/2016
• Est. Priority Date: 03/23/1999
• Status: Expired due to Fees

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Wilding, Peter, Yost, Kyle, Saylor, Michael, Trenkamp, Robert
• Primary Examiner(s): VU, BAI DUC
• Application Number:
  US13/685,220
• Time in Patent Office: 1,429 Days
• Field of Search: None
• US Class Current: 1/1
• 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 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 computer program product for managing automatic generation of output from a data repository, the computer program product comprising:

one or more tangible, non-transitory computer-readable storage devices; and

program instructions, stored on at least one of the one or more tangible, non-transitory computer-readable storage devices that, when executed, cause a computer to;

process at least one scheduled service, the at least one scheduled service comprising one or more reports to be run against at least one data repository;

establish a maximum number of subscriber output devices to receive output from the at least one scheduled service;

resolve dynamic recipient lists to generate a list of subscriber output devices to receive the output from the at least one scheduled service; and

automatically forward the output to one or more subscriber output devices specified for the at least one scheduled service.

2. The computer program product of claim 1, wherein the program instructions, when executed, further cause a computer to:

eliminate duplicate report requests prior to running the one or more reports against the at least one data repository.

3. The computer program product of claim 1, wherein the program instructions, when executed, further cause a computer to:

establish a maximum number of subscribers for the at least one scheduled service.

4. A system for managing automatic generation of output from a data repository, the system comprising:

a processor configured to execute computer program modules, the computer program modules comprising;

a service generation module that processes at least one scheduled service, establishes a maximum number of subscriber output devices to receive output from the at least one scheduled service, and resolves dynamic recipient lists to generate a list of subscriber output devices to receive the output from the at least one scheduled service, the at least one scheduled service comprising one or more reports to be run against at least one data repository; and

a broadcast module that automatically forwards the output to one or more subscriber output devices specified for the at least one scheduled service.

5. A computer-implemented method of managing automatic generation of output from a data repository, the method being implemented by a computer that includes a physical processor, the method comprising:

processing at least one scheduled service, the at least one scheduled service comprising one or more reports to be run against at least one data repository;

establishing a maximum number of subscriber output devices to receive output from the at least one scheduled service;

resolving dynamic recipient lists to generate a list of subscriber output devices to receive the output from the at least one scheduled service; and

automatically forwarding the output to one or more subscriber output devices specified for the at least one scheduled service.

6. A computer program product for managing automatic generation of output from a data repository, the computer program product comprising:

one or more tangible, non-transitory computer-readable storage devices; and

program instructions, stored on at least one of the one or more tangible, non-transitory computer-readable storage devices that, when executed, cause a computer to;

subscribe subscribers to at least one service, the at least one service comprising one or more reports to be run against at least one data repository;

process the at least one service according to a schedule;

establish a maximum number of subscriber output devices to receive output from the at least one service;

personalize the output from the at least one service for subscribers; and

forward the output to one or more subscriber output devices of subscribers.

7. The computer program product of claim 6, wherein the program instructions, when executed, further cause a computer to:

resolve dynamic recipient lists to generate a list of subscriber output devices to receive output from the at least one service.

8. The computer program product of claim 6, wherein the program instructions, when executed, further cause a computer to:

eliminate duplicate report requests prior to running the one or more reports against the at least one data repository.

9. The computer program product of claim 6, wherein the program instructions, when executed, further cause a computer to:

establish a maximum number of subscribers for the at least one service.

10. A system for managing automatic generation of output from a data repository, comprising:

a processor configured to execute computer program modules, the computer program modules comprising;

a subscriber interface module that subscribes subscribers to at least one service, the at least one service comprising one or more reports to be run against at least one data repository;

a service generation module that processes the at least one service according to a schedule, that establishes a maximum number of subscriber output devices to receive output from the at least one service, and that personalizes the output from the at least one service for subscribers; and

a broadcast module that automatically forwards the output to one or more subscriber output devices of subscribers.

11. A computer-implemented method of managing automatic generation of output from a data repository, the method being implemented by a computer that includes a physical processor, the method comprising:

subscribing subscribers to at least one service, the at least one service comprising one or more reports to be run against at least one data repository;

processing the at least one service according to a schedule;

establishing a maximum number of subscriber output devices to receive output from the at least one service;

personalizing the output from the at least one service for subscribers; and

forwarding the output to one or more subscriber output devices of subscribers.

12. A computer program product for managing automatic generation of output from a data repository, the computer program comprising:

one or more tangible, non-transitory computer-readable storage devices; and

program instructions, stored on at least one of the one or more tangible, non-transitory computer-readable storage devices that, when executed, cause a computer to;

create a service to be processed 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 the service output;

create a data record for the subscriber, the subscriber data record including an address associated with the specified output device, and one or more personalization filters based on the specified personalization criteria;

process the service according to the schedule to generate the service output, wherein the service comprises one or more reports to be run against at least one data repository;

establish a maximum number of subscriber output devices to receive the service output from the service;

personalize the service output for the subscriber according to the one or more personalization filters included in the subscriber data record; and

forward the personalized service output to the specified output device of the subscriber.

13. The computer program product of claim 12, wherein the service output comprises multiple reports and the subscriber data record includes multiple personalization filters, and wherein the program instructions, when executed, further cause a computer to:

apply a different personalization filter to each of the multiple reports.

14. The computer program product of claim 12, wherein the service output comprises multiple reports, and wherein the program instructions, when executed, further cause a computer to:

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

15. A system for managing automatic generation of output from a data repository, the system comprising:

a processor configured to execute computer program modules, the computer program modules comprising;

a service definition module that creates a service to be processed according to a schedule;

a service generation module that processes the service according to the schedule to generate service output and that establishes a maximum number of subscriber output devices to receive the service output from the service, wherein the service comprises one or more reports to be run against at least one data repository;

a subscription interface module that receives from a subscriber to the service a specified output device to which the service output is to be delivered, and specified personalization criteria for personalizing the service output;

a personalization module that creates a data record for the subscriber, the subscriber data record including an address associated with the specified output device, and one or more personalization filters based on the specified personalization criteria; and

a broadcast module that forwards the service output to the specified output device of the subscriber, wherein the forwarded service output is personalized for the subscriber according to the one or more personalization filters included in the subscriber data record.

16. A computer-implemented method of managing automatic generation of output from a data repository, the method being implemented by a computer that includes a physical processor, the method comprising:

creating a service to be processed according to a schedule;

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

creating a data record for the subscriber, the subscriber data record including an address associated with the specified output device, and one or more personalization filters based on the specified personalization criteria;

processing the service according to the schedule to generate the service output, wherein the service comprises one or more reports to be run against at least one data repository;

establishing a maximum number of subscriber output devices to receive the service output from the service;

personalizing the service output for the subscriber according to the one or more personalization filters included in the subscriber data record; and

forwarding the personalized service output to the specified output device of the subscriber.