Abstract: The invention provides for a method for producing reports for business intelligence that adapt automatically to a context, defined by a locale variable. A parameter map is defined, based on locale key and field names, and a report layout is produced that contains one or more macrotized database language expressions that include partial expressions built using the parameter map. Later, once a user selects a locale, the partial expression resulting from a lookup in the parameter map using the locale is used to modify one or more macrotized database language expressions. Finally, the resulting valid database language expressions are applied to the database to produce a report.

Abstract: A system and method are provided for the automatic updating or installation and invoking of a requested application on a client. The system and method form an application provision system which operates within a network containing at least one client and at least one server. The application provision system includes; a server resident process for controlling the provision of an application to a client, and client-server functionality that is deliverable to the client, the client-server functionality the provision of the application to the client by communicating with the server resident process.

Abstract: Method and system for rendering a page set having logical pages into a physical report output page. The logical pages may have implicit or explicit repeating orders, implicit or explicit rendering orders; or identification attributes.

Abstract: A new method of customized retrieval and presentation of information from a relational database is disclosed. The customization is achieved by modifying a first application for retrieval and presentation of information from a database in accordance with input provided by the user, at the time when the execution of the first application is requested by the user. The user input is solicited and gathered by a second application associated with the first application. After the user input is completed, the second application generates a script which modifies the first application. The modified first application is then executed and the requested information is retrieved and presented to the user in the form customized by the user input.

Abstract: An enterprise business planning system includes a server to execute an enterprise planning session for a set of enterprise contributors in accordance with an enterprise model, wherein the enterprise model defines hierarchically arranged nodes and associates the enterprise contributors with the nodes. The system further comprises a web browser executing on a remote computing device of one of the enterprise contributors to communicate contribution data between the remote computing device and the server, and an inline compression module executing on the remote computing device. The inline compression module automatically compresses outbound communications from the web browser to the server, and automatically decompresses inbound communication received from the server and forwards the decompressed inbound communications to the web browser.

Abstract: The invention, when incorporated in a drill-through modeling tool (DMT), allows all the elements affecting drill-through behavior to be aggregated in a single structure or set of structures, thereby allowing administration to be simplified, and also permitting easier integration with third-party tools. The invention also provides for graphical displays of drill-through paths for a DMT user. These displays show the parameters and dependencies of each drill-through path and allow tool users to obtain a quick overview of the drill-through network and further, they allow the tool user to confirm drill-through dependencies at a glance. Drill-through objects may thus be manipulated and maintained in a graphical manner.

Abstract: A spreadsheet environment is utilized to interact with a multidimensional data store associated with the enterprise planning session. In general, a conventional spreadsheet application is extended to provide additional functionality for interacting with the multidimensional data store maintained by the enterprise planning system. Instances of the extended spreadsheet application execute on a client computing device, and present a user with a two-dimensional representation of a portion of the multidimensional data store. For example, the extended spreadsheet application may present user with a workbook that includes one or more worksheets within which the user may view and update his planning data. In this manner, the extended spreadsheet application functions as an interface between two-dimensional worksheets maintained by the computing devices and the multidimensional data store maintained by the enterprise planning system.

Abstract: A query framework system is provided. The query framework system comprises a query framework service for consuming a query and returning a result set, a provider application programming interface for defining a consistent application programming interface for providers, one or more providers incorporating query processing logic, and a configuration repository for storing the list of the providers in the query framework system and their properties.

Abstract: An enterprise planning system accumulates newly submitted planning data in a manner that minimizes database contention, allows ongoing entry of planning data, and allows queries against that data to return consistent results while accumulations are ongoing. An “update process” is the set of activities required to bring the entire data store up to date with a newly submitted value set. The activities may be interleaved with an arbitrary number of other submitted value set changes (other update processes). The enterprise planning system also provides for labeling of consistent sets and removal of obsolete versions of value sets.

Abstract: Method and system in an event management system is disclosed. The method includes the step of creating an agent on a server in an event management system for monitoring an event. The event is present when a data achieving a predefined status defined by a business rule. The event management system includes a data source for generating the notification. The method further includes the steps of running the agent according to a schedule; generating the notification upon occurring of the event.

Abstract: A tabular set provider is provided for processing a data agnostic business intelligence query with relational set operations, herein called a relational query against a multidimensional datasource. The tabular set provider comprises a query interceptor, a query decomposer, an OLAP query provider interface, and an operation module. The query interceptor is provided for detecting and intercepting a data agnostic Business intelligence query that has relational set operations that is issued against one or more multidimensional data sources. The query decomposer is provided for decomposing the operands of the set operation in the input query into one or more sub-queries. The OLAP query provider interface is provided for sending the OLAP supported sub-queries to an OLAP query provider and receiving results. The operation module is provided for using set operation functionality provided by a relational query provider that performs the set operations locally on the results of the OLAP data extraction.

Abstract: A business process management system provides one or more business intelligence (BI) gadgets, each providing a predefined functionality for extracting data from one or more data sources of an organization. The system allows embedment of one or more BI gadgets into a business process activity form for presenting to a user relevant data for a business process activity represented by the business process activity form.

Abstract: Transformations are provided for transforming a metadata model that contains model objects. The metadata model has a multiple layers including a lower layer containing one or more lower abstraction model objects having a lower abstraction level and a higher layer containing one or more higher abstraction model objects having a higher abstraction level. The transformations transform the model objects from the lower layer to the higher layer.

Abstract: A system for providing feedback associated with the planning of a query is provided. The system comprises a query planning mechanism capable of determining transformations required for the execution of the query, and a monitoring mechanism for monitoring and extracting feedback information from the planning mechanism, the feedback information including an indication of the transformations.

Abstract: The invention provides an application programming mechanism and technique that makes referencing data look as if the data is dynamically allocated by the process. The invention also provides a mechanism whereby persisted data is shared across all processes on the same computer that access it. Small, process specific structures are created on demand as the program accesses the persisted data and makes use of the underlying memory mapping and linking technologies inherent in modern operation systems. The technique is especially useful in large data repositories where it simplifies the sharing of data between instances of an application, and also permits sharing of data between different applications. It allows for the data to be highly referenced internally while not requiring the extra memory used by pointer swizzling at runtime.

Abstract: An enterprise planning system provides interview-based enterprise planning techniques that enable users to interact with a simple, manageable and understandable front-end for complex planning software. The interview-based enterprise planning system guides users through an enterprise planning process that captures the planning data with a set of ordered input screens that include an interview-based progression of an enterprise planning session. The interview-based enterprise planning system presents an interview-based question and answer planning process in which users enter input data through a combination of, for example, input fields, yes-no answers to interview questions, and drop-down boxes. The interview-based planning process may be customized on an organization wide basis, on a per plan basis, and/or on a per user basis.

Abstract: In general, the invention is directed to techniques for developing an enterprise planning model in cascaded planning stages. For example, an enterprise planning system receives data that defines an enterprise planning session from a set of analysts in cascaded planning stages. The analysts associated with each subsequent planning stage refine the enterprise planning model defined by analysts associated with previous planning stages. In this manner, the set of analysts may define an enterprise planning model that may allow large, diverse organizations to establish planning standards across dozens or hundreds of business units, while allowing the business units to extend the planning standards to further refine the planning sessions.

Abstract: A time dimension management system is provided for managing time dimension of a data analyzing system for analyzing data stored in a data store based on a time data structure. The time dimension management system comprises a date selector controller and a calendar coordinator. The date selector controller is provided for controlling a date selector that presents to a user a standard calendar and a business calendar. The date selector controller has a standard calendar manager for managing presentation of the standard calendar for allowing the user to select a date on the standard calendar, and a business calendar manager for managing presentation of the business calendar to represent the time data structure that the data analyzing system uses, and allowing the user to select a date on the business calendar. The calendar coordinator is provided for coordinating the standard calendar manager and the business calendar manager to indicate a selected date on the standard calendar and the business calendar.

Abstract: The invention is directed to a budget planning system that improves the accuracy and predictability of budget planning within large organizations by enabling organizations to reconcile corporate financial models and organizational targets with detailed spending forecasts. The budgeting system includes a database that is configured to store data defining a budgeting model for the organization. The model has a plurality of hierarchically arranged nodes, each node corresponding to a “contributor” that either provides forecast data or review data provided by contributors associated with lower level nodes. The system is configured to capture target data from a set of financial analysts, capture forecast data from the contributors and reconcile the target data and the forecast data according to the model.

Abstract: An enterprise business planning system includes a database having a relational data area and a transactional data area, and a server to store within the transactional data area contribution data received from a set of enterprise contributors. The server publishes the contribution data from the transactional data area to the relational data area. The transactional data area may include a set of contribution slots and a set of aggregations slots hierarchically related in accordance with an enterprise model. The relational area includes a set of related tables defined in accordance with the model. The transactional data area supports real-time interaction with the enterprise contributors, while the relational data area allows detailed statistical analysis and report generation.