Abstract: Dynamic sourcing, in which a data request that is associated with a query is received and a parameter of data needed for satisfaction of the query is identified. Parameter information defining data available in at least one cube stored in a cache is accessed and the parameter is compared with the parameter information. Based on comparison results, it is determined whether one or more cubes in the cache include sufficient data to satisfy the query. In response to a determination that one or more cubes include sufficient data to satisfy the query, a response to the data request is generated by executing the query against the one or more cubes. In response to a determination that the cubes do not include sufficient data to satisfy the query, a response to the data request is generated by executing at least a portion of the query against a database system.

Abstract: A method and system for accomplishing closed-loop transaction processing in conjunction with interactive, real-time, voice transmission of information to a user is disclosed. A voice-based communication between a user and a first system is established and a report is transmitted to the user. The report might comprise information and at least one request for user input based on said information. In response to the report, the user can request a transaction based on said information. The requested transaction is completed automatically by connecting to a second system for processing.

Abstract: A method and system for accomplishing closed-loop transaction processing in conjunction with interactive, real-time, voice transmission of information to a user is disclosed. A voice-based communication between a user and a first system is established and a report is transmitted to the user. The report might comprise information and at least one request for user input based on said information. In response to the report, the user can request a transaction based on said information. The requested transaction is completed automatically by connecting to a second system for processing.

Abstract: A system and method for the creation and delivery of automated, personal information service gathers news, weather, financial and other data for transmission by telephone or other media. The recipient of a given voice broadcast may be detected and discriminated to adjust the content delivery. For instance, if a machine pick-up is detected, the call may be terminated or the message curtailed. Secondary recipients may be authorized in a subscriber's service profile, and other delivery preferences may be registered.

Abstract: The present invention presents security and user account integration with remote authentication servers, (e.g., repositories not owned by the server). Integration may occur with Lightweight Directory Access Protocol (LDAP), an operating system (e.g., Microsoft Windows™ NT™) authentication, custom account repositories and others. For example, the server may synchronize associated user lists with a remote repository. In another example, the server may also make external calls to remote authentication servers to validate a user's username and password. Other information may be validated.

Abstract: A system and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including information derived from on-line analytical processing (OLAP) systems and other data repositories is disclosed. The system and method includes the ability to deploy personalized voice services through a live or recorded personalized broadcast. In particular, the system and method access personalized information and generate personalized markup documents from the personalized information. The personalized markup document is converted to a form that is suitable for over-air transmission and transmitted to a subscriber of the voice service.

Abstract: A system and method for syntax abstraction in query language generation in an online analytical processing system, a business intelligence system, a reporting system, or a data mining system. The system generates one or more query language statements that can be run against one or more data sources to return a desired data result set. The system includes a syntax pattern selector module and a statement assembly module. The syntax pattern selector module selects a syntax pattern corresponding to a desired function and a syntax standard. The statement assembly module populates the syntax pattern with an argument data set associated with the desired data set. The result is the generation of one or more query language statements with the correct function, syntax, and data parameters to return the desired data result set from the data sources. A method and medium having processor readable code therein are also described.

Abstract: Systems and methods are provided for filtering data in a database using an execution plan. The execution plan has a first processing pass against the database that calculates a filter set using a filter criteria, and a second processing pass against the filter set that calculates a report result.

Abstract: An reporting system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A collection of answers is built up in a resolution object. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A resolution object may be created and saved before the execution of a report. The saved resolution object can then be used to answer prompts at the time of the report execution.

Abstract: A reporting system that incorporates a context sensitive prompt object in a report definition to enable questions to be answered automatically by the reporting system (e.g., decision support system, business intelligence and OLAP) at report execution time. The context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports. The answer is defined at least in part by a contextual feature of the report execution.

Abstract: System and methods for real-time, interactive transmission of information about travel schedules and creation of travel schedules are provided. A user defines desired travel parameters, such as dates, times, costs and the like related to a travel component. Travel components are reviewed to determine if traveler parameters are triggered. If a travel component triggers traveler parameters, options for other travel components may be determined. A user may be contacted and communicated information about the travel component and options, thereby allowing a user to interactively create a travel schedule.

Abstract: An reporting system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a report at execution time. A prompt object contains a single question to be answered, validation values for the answer, and attributes indicating how the prompt object is to be processed. A collection of answers is built up in a resolution object. A report is thus defined by selecting prompt objects in place of templates, filters, or any of the aspects of a template or filter. As a separate object, a single prompt may be issued once and the answer supplied to each reference to the prompt object in a report. A resolution object may be created and saved before the execution of a report. The saved resolution object can then be used to answer prompts at the time of the report execution.

Abstract: A technique for limiting access to the resources of a system is disclosed. In one embodiment, wherein the system has a server for processing requests, and wherein the server supports a plurality of projects, the technique includes receiving a request to access the resources of the system. The request is denied based upon an application level and a setting level, wherein the application level is associated with one of a plurality of functional layers within the system that is affected by the request, and wherein the setting level is a limiting value associated with one of the server alone and the server with one or more of the plurality of projects. The limiting value limits an operation on one of the plurality of functional layers, thereby limiting access to the resources of the system.

Abstract: A method and system for implementing database connection mapping for mapping a user who may be associated with a group of users to an appropriate database via a database connection wherein the database connection comprises information for locating and logging into the appropriate database. A centralized server may control the access to databases, thereby ensuring efficient use of database resources. A user may log into a server and then be mapped to an appropriate database via a database name and login, provided by a database connection. Database connection mapping may provide the ability to map multiple users to the same database login as well as the ability to map different users to different database logins.

Abstract: A system and method for creation and automatic deployment of personalized, dynamic and interactive voice services relating to subscriber entertainment, including information derived from on-line analytical processing (OLAP) systems. More specifically, the invention relates to a system and method that enable personalized delivery of entertainment-related information in real-time, via natural language voice communication with a voice-enabled terminal device.

Abstract: A system and method for monitoring and analyzing statistics regarding informational and transactional data is provided. Data distribution servers provide e-mail and other messages of topical interest to a subset of the subscribers. The content may be generated by an OLAP based channel database system, and the output may also be communicated to individuals via spreadsheet programs data, pager, telephone, mobile phone, fax, personal digital assistants, HTML e-mail and other formats, including a workbook file attachment. Statistics regarding the provided reports are generated and compiled. Analysis of the statistics may enable evaluations of system performance, application usage, and optimal configurations for the system.

Abstract: A system and method for a enabling transactions based on provided informational and transactional data. Data distribution servers provide e-mail and other messages of topical interest to a subset of the subscribers. The content may be generated by an OLAP based channel database system, and the output may also be communicated to individuals via spreadsheet programs data, pager, telephone, mobile phone, fax, personal digital assistants, HTML e-mail and other formats, including a workbook file attachment. Reports generated may enable a subscriber to perform one or more transactions is response to the content, thereby permitting interaction with the report.

Abstract: A system and method for manipulating objects between related projects. Dependencies between object are checked as objects are moved between projects. The dependency review enables all dependent object to be copied simultaneously. The system and method facilitates the management of multiple stages of a project by permitting as object and all of its modified dependents to be easily copied from one stage to another.

Abstract: The methods and systems of the invention provide for processing of jobs, that comprise one or more reports to be processed in a reporting system, by assigning a priority to a job. The priority may include a queue or a queue set priority, as well as a sub-queue priority in accordance with some embodiments of the methods and systems of the invention. Once the priority is assigned, the job is placed into a selected queue, selected from a plurality of possible queues, based on the queue priority assigned to the job. The job may also be designated to a particular sub-queue within the selected queue, i.e., based on the sub-queue priority. Then, the job is processed based on the priority.

Abstract: A method and system for telephone-based service utilization and control in conjunction with interactive, real-time, voice transmission of information to a user is disclosed. A voice service system provides creation and automatic deployment of personalized, dynamic and interactive voice services, including information derived from on-line analytical processing (OLAP) systems and other data repositories. In conjunction with such services, a user may use a telephone to control such services. For example, the user may subscribe and unsubscribe to a service using the telephone, be notified of new services via the telephone, and retrieve sound files via the telephone.