System and method for automatic transmission of on-line analytical processing system report output

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.

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.