US6173310B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for automatic transmission of on-line analytical processing system report output
Assignee: Reporting Technologies Inc
•
Filing: 1999-06-30
•
Granted: 2001-01-09
•
Expires: 2019-06-30
Abstract
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.
Inventors
- 👤 Kyle N. Yost
- 👤 Peter G. Wilding
- 👤 Robert G. Trenkamp
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 06:49
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/95; G06F16/958; G06F16/953; G06F16/9535
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
160 words
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.
Claim 2
Dependent Claim
160 words
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.
Claim 3
Dependent Claim
19 words
The server system of claim 1 further comprising service definition means for receiving definitions of one or more services.
Claim 4
Dependent Claim
31 words
The server system of claim 2 wherein the server definition means comprises service scheduling means for enabling a user to specify the schedule for when a service is to be processed.
Claim 5
Dependent Claim
26 words
The server system of claim 3 wherein the service processing means processes services according to the schedule specified in the server definition means for the services.
Claim 6
Dependent Claim
34 words
The server system of claim 1 wherein the server system stores one or more services for processing and further comprising subscription means for receiving a list of one or more subscribers to a service.
Claim 7
Dependent Claim
49 words
The server system of claim 5 wherein the subscription means enables specifying subscribers to a service by a dynamic recipient list and further comprising dynamic recipient list resolution means for resolving the subscribers in the dynamic recipient list and providing that list of subscribers to the output forwarding means.
Claim 8
Dependent Claim
36 words
The server system of claim 1 wherein the service may comprise an alert service and wherein the output forwarding means automatically forwards output from an alert service only when one or more alert criteria are satisfied.
Claim 9
Dependent Claim
34 words
The server system of claim 1 wherein the service may comprise a scheduled service and wherein the output forwarding means automatically forwards output from a scheduled service each time the schedule service is processed.
Claim 10
Dependent Claim
35 words
The server system of claim 1 wherein the output forwarding means forwards the output to a subscriber output device selected from the group consisting of: electronic mailbox, facsimile, printer, mobile phone, telephone, PDA, and pager.
Claim 11
Independent Claim
139 words
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.
Claim 12
Independent Claim
139 words
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.
Claim 13
Dependent Claim
21 words
The method of claim 10 further comprising the step of receiving a schedule for when a service is to be processed.
Claim 14
Dependent Claim
19 words
The method of claim 11 wherein the processing step processes services according to the schedule set for a service.
Claim 15
Dependent Claim
21 words
The method of claim 10 further comprising the step of receiving a list of subscribers to receive output from a service.
Claim 16
Dependent Claim
41 words
The method of claim 13 wherein the step of receiving subscribers comprises the step of receiving a dynamic recipient list for a service and further comprising the step of resolving the dynamic recipient list to determine the subscribers for a service.
Claim 17
Dependent Claim
17 words
The method of claim 10 further comprising the step of receiving definitions for one or more services.
Claim 18
Dependent Claim
34 words
The method of claim 10 wherein the service may comprise an alert service and wherein the forwarding step involves forwarding output from an alert service only when one or more alert criteria are satisfied.
Claim 19
Dependent Claim
32 words
The method of claim 10 wherein the service may comprise a scheduled service and wherein the forwarding step involves forwarding output from a scheduled service each time the schedule service is processed.
Claim 20
Dependent Claim
39 words
The method of claim 10 wherein the step of forwarding comprises the step of forwarding output from the service to an output device selected from the group consisting of: electronic mailbox, facsimile, printer, mobile phone, telephone, PDA, and pager.
Claim 21
Dependent Claim
188 words
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.
Claim 22
Dependent Claim
188 words
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.
References Cited (Backward Citations)
US5918225A
Cited
US5974441A
Cited
US5692181A
Cited
US5765028A
Cited
US5956693A
Cited
US6012083A
Cited
US6038561A
Cited
US5893905A
Cited
US5852819A
Cited
US5940818A
Cited
US6012066A
Cited
US5918232A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-01-09 | 2004-07-10 | 2005-01-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-01-09 | 2008-07-10 | 2009-01-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-01-09 | 2012-07-10 | 2013-01-09 | $7700.00 | Window Closed / Lapsed |