System and method for automatic transmission of on-line analytical processing system report output
DCFirst Claim
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.
6 Assignments
Litigations
0 Petitions
Accused Products
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.
-
Citations
19 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
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. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
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.
-
Specification