System and method of adapting automatic output of service related OLAP reports to disparate output devices

A method for generating output from an on-line analytical processing system to user output devices comprising the steps of:

• processing at least one scheduled service in an on-line analytical processing system according to a schedule established for the service and generating a service output, each service comprising at least one query to be performed by the on-line analytical processing system and at least one user device subscribed to that service;
• enabling a plurality of subscribers to subscribe to the scheduled service and enabling the subscriber to specify at least one user output device at which to receive service outputs from the service;
• wherein each user device subscribed to that service is associated with a device-specific style that designates the format in which that particular type of user device is to output to the service outputs to a user to maintain the integrity of the service outputs;
• determining whether to forward the generated output to one or more user devices based on output conditions specified for each user device subscribed to the service;
• creating a device-specific formatted output for each user device subscribed to the service selected to receive the output according to a selection of predefined values specified for each of a plurality of predefined parameters provided by the style specified for the user output device, and
• automatically forwarding a device-specific formatted service output to each of the user output devices selected to receive the output for that service;
• wherein the determining step comprises determining whether each user device subscribed to the service is an alert subscription or a periodic subscription and selecting the user device if it is a periodic subscription or if an alert condition specified in the alert subscription has been satisfied.

A medium having processor readable program code embodied therein for generating output from an on-line analytical processing system to user output devices, the processor readable code in the medium comprising:

• service processing code for causing a processor to process at least one scheduled service according to the schedule established for the service in an on-line analytical processing system and generating a service output, each service comprising at least one query to be performed by the on-line analytical processing system and at least one user device subscribed to that service;
• service subscribing code for causing a processor to enable a plurality of subscribers to subscribe to the scheduled service and enabling the subscriber to specify a user output device at which to receive a report from the service;
• wherein each user device subscribed to that service is associated with a device-specific style that designates the format in which that particular type of user device is to output to the service output to a user to maintain the integrity of the service output;
• determining code for causing a processor to determine whether to forward the generated output to one or more user devices based on output conditions specified for each user device subscribed to the service;
• formatting code for causing a processor to create a device-specific formatted output for each user device subscribed to the service selected to receive the output according to a selection of predefined values specified for each of a plurality of predefined parameters provided by the style specified for the user output device;
• forwarding code for causing a processor to forward a device-specific formatted service output to the user output devices selected to receive the output;
• and
• wherein the determining code determines whether each user device subscribed to the service is an alert subscription or a periodic subscription and selects the user device if it is a periodic subscription or if an alert condition specified in the alert subscription has been satisfied.