摘要:
Techniques are described for specifying virtual datasets within an enterprise software system. A computer-implemented system, for example, includes an enterprise planning system and a computing device coupled to the enterprise planning system via a network connection. The computing device includes an object store that stores a dataset, an application programming interface (API) that defines an operation for specifying the virtual dataset from the dataset, and an object model that stores a virtual dataset to the object store in response to receiving the operation defined by the API. The computing device further includes a plurality of applications that utilize the virtual dataset for a further operation defined by the API without resolving the virtual dataset. Because virtual dataset may be utilized without first resolving them, the virtual datasets may require less storage space within a memory, may automatically remain synchronous with the underlying dataset, and may quickly layer to more readily perform complicated operations.
摘要:
A parallel detail join system for processing a many-to-one-to-many relationship is provided. The system comprises a parallel detail analysis module for detecting a many-to-one-to-many relationship among elements, and a parallel detail transformation module for generating a SQL: 1999 statement to handle the many-to-one-to-many relationship.
摘要:
The invention introduces a method and system to automatically derive the relationships between query subjects and query items within query subjects so that problems such as those that result in double courting of information are avoided. It provides for creating a report by first defining a model based on an existing database comprising two or more query subjects, each query subject comprising at least one fact query item and one primary key, then generating a hierarchy of sets and subsets of key query items within the model. Next a further fact is introduced into one of the query subjects. The expression is decomposed into sub-queries to prevent double counting of data in ambiguously defined situations. This is achieved using the introduced fact to determine that such decomposition is required. Finally, the data is accessed using the sub-queries, and a report is produced.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
The invention comprises a method and system for reducing the apparent complexity faced by a user when confronted by this modeling environment. It provides for a metadata model that represents one or more data sources, the metadata model comprising a query layer combining tee functions of a data access layer and a business layer. The query layer includes query subjects that describe how to retrieve data from the data sources, and the query subjects contain query items. The query layer also allows the use of data access language statements which permit the use of more complex computed query subjects and query items.