Abstract: An report system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system (e.g., decision support system, business intelligence and OLAP) 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 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.

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 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 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: A technique for project partitioning in a cluster of servers is disclosed. In one particular exemplary embodiment, the technique may be realized as a method for partitioning a plurality of projects among a cluster of servers. The method may comprise determining a status of project partition among the cluster of servers. The method may also comprise generating a partition plan for re-partitioning the plurality of projects among the cluster of servers based at least in part on the status and a partition policy, wherein the partition policy comprises one or more rules selected from a group consisting of a user specified project-server association rule, a weighted balancing rule, and a project redundancy rule. The method may further comprise communicating the partition plan to each of the cluster of servers. The method may additionally comprise causing the plurality of projects to be re-partitioned among the cluster of servers based on the partition plan.

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 system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set.

Abstract: A system for a personal intelligence network provides 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 On-Line Analytical Processing (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, Hypertext Markup Language (HTML) e-mail and other formats, including a workbook file attachment. Reports generated may enable a subscriber to act upon the content within the report, thereby providing an interactive component to the report. Subscriber actions or inaction to the report and content may be obtained and analyzed, including analysis in connection with the other informational and transactional data.

Abstract: A report resolution system that includes prompt objects used to define every aspect of a report and specifically an object-prompt object. To resolve a report with prompt objects, a report instance is created and passed to a resolution server that collects the prompt objects contained therein to create a resolution object that includes the prompt questions from the prompt objects. A report server raises an event to prompt the user to respond to the questions in the resolution object.

Abstract: Security filters that manage user access to data based on user identification and other data when a user attempts to access information via a query or other mechanisms. Security filters may be implemented to prevent users from viewing or otherwise accessing certain data in a database or other source of information in a reporting or other system. The level of access authorized by a security filter may be based on a user's role, capabilities, or other criteria. For example, a regional manager may have a security filter that allows a user to view data from the user's particular region regardless of the report the user runs. A security filter may include a filter expression, a top level and a bottom level where each component may be further define a user's ability to access certain data.

Abstract: A system that incorporates prompt objects in a report definition to enable a user to specify answers to questions to customize a reporting system, decision support system, business intelligence and OLAP 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 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 prompt object may also contain another prompt object nested within it, in which the answer to an inner prompt object is used by the system to validate the answer to an outer prompt object.

Abstract: A layered architecture for communication of reporting system reports to users connecting via a web server. Users communicate via HTTP with web servers without download of plugins or executable files to the user system. The web servers are clustered to balance requests and transmit the requests. The web servers pass report requests via XML to the business intelligence servers to perform the work with the databases. The business intelligence servers convert reports into XML and provide the XML-based version to the web server. The web server then transmits an HTML or DHTML report back to the client over the web.

Abstract: A method and system is provided for exchanging information over a computer network. A network server computer system receives a query request from at least one client computer system over a computer network. The query request is formatted into an extensible markup language query document according to an extensible markup language document application program interface. The extensible markup language query document is transmitted to at least one business intelligence server computer system. The at least one business intelligence server computer system retrieves the information requested in the extensible markup language query document from at least one data storage device.

Abstract: A technique for handling server session requests in a system having a plurality of servers is disclosed. In one embodiment, the technique includes receiving a request to create a session on one of the plurality of servers. In response to the request, a primary session is created on a first of the plurality of servers. After the primary session is created, at least one other of the plurality of servers are notified that the primary session has been created. Such notification allows for a backup session on the at least one other of the plurality of servers to take over for the primary session upon a failure on the first of the plurality of servers.

Abstract: The invention provides a configuration tool to allow a user to build a custom-selected data object hierarchy, for business intelligence or other purposes. Under conventional data storage technologies, the physical layout of the disk drive or other media has dictated what logical views and searches a user could run on the underlying data. For instance, levels could not be readily skipped or many-to-many data object relationships were difficult to maintain. In the invention, a user may select and connect a set of data objects into a hierarchy of their choosing, to permit desired reports and other manipulations on the data to be performed. The hierarchy may be edited, and entry points may be defined. Different levels of security may be applied to the different levels of the hierarchy. Multiple hierarchies or representations may be built for one database or other data source.

Abstract: A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.

Abstract: A system and method for creating a custom grouping of data in a database. A custom group object is created, a plurality of custom group elements are defined, each of the custom group elements being a subset of the custom group object and being defined by a different filter, each one of the different filters representing a logical expression of qualifications based on the data or a derived calculation of the data. Each of the different filters is resolved against the data or a subset of the data, and the plurality of custom group elements are grouped into a consolidated result set which in not naturally existing in the data structure.

Abstract: A system and method for defining and using logical extensions to a set of data stored in a relational database. A metadata definition for various extensions is stored to explain how to extend data as it is stored into a logical representation suitable for reporting and calculating purposes. An analytical engine translates report requests into SQL queries to access the physically stored data using the metadata extension definitions if necessary to generate appropriate results. Here, data is stored in at least one table that is physically keyed by a set of attributes with the attribute determining the granularity or level of data contained within the tables. A report request causes the engine to calculate and/or display the data at a lower level of granularity than exists, thereby invoking the metadata definitions. The extension definitions may describe how to extend data from the physical to the logical including joins and allocation rules.