Abstract: A system provides multidimensional tuple Hilbert ordering within a linear storage structure to enable more consistent and efficient access to stored multidimensional tuples. The database system comprises a tuple storage module that receives multidimensional data elements, where each multidimensional data element is defined by a plurality of different object types, and where each object is associated with a different dimension within a multidimensional data space. The tuple storage module further forms a respective tuple for each of the multidimensional data elements by mapping each object to an associated reference and applies a Hilbert function to the references of each of the tuples to determine a respective Hilbert ordering for each of the tuples. The system further comprises a linear data storage structure that includes a B-tree for storing the Hilbert ordering.

Abstract: Techniques are described of applying on-line analytical processing (OLAP) to associative databases. For instance, a database adapter implemented in computer hardware or software may automatically create dimensions in a multidimensional dataset for data types in an associative database. The database adapter may then query the associative database for metadata that describes index values of each dimension of the multidimensional dataset. The database adapter may then query the associative database for data values to populate individual cells of the multidimensional database.

Abstract: A system and method of producing a business report from data contained in a computer based business intelligence system, is provided. The method includes defining one or more macro functions, and producing a report layout containing one or more macrotized database language expressions. The macrotized database language expression having at least one of the macro functions. The method includes produce one or more valid database language expressions for a database query by modifying the one or more macrotized database language expressions in dependence upon the return value of the at least one of the macro functions, and applying the one or more valid database language expressions to one or more database to produce the business report.

Abstract: Techniques are described for compressing multidimensional datasets. For instance, a compression module obtains lists of indices of data along dimensions of the multidimensional dataset. The compression module calculates lists of offset values from the lists of coordinates. The compression module then performs a statistical redundancy data compression algorithm on the lists of offset values. Because the lists of offset values may contain more repetitious values than the initial lists of coordinates, a compression ratio on the multidimensional dataset may be higher than without first calculating the lists of offset values.

Abstract: A member naming system is provided for naming members of a dimension in a data analyzing system having a receiver for receiving a pattern. One example of the dimension is a time dimension containing time periods. The pattern has a sequence of pattern components for defining a name. A time period is defined by a start time, an end time, a relationship and a level in a single time hierarchy. The time period naming system further has an interpreter for interpreting the sequence of pattern components, and a generator for generating the time period name based on the interpretation of the sequence of pattern components within a context of the relationship of the time period in the time hierarchy.

Abstract: A model edit control system controls editing of a data model. A model repository manager allows multiple users to copy a stored model stored in a repository for executing changes on multiple model copies in parallel. An action log manager crates a model action log for the stored model and tracks actions executed on the stored model. The action log manager also creates a current action log for each model copy to record actions executed on the model copy. A model merger manager merges the model copies into the stored model in the repository, by playing the actions in the current action log against the stored model in the repository.

Abstract: An enterprise software system provides dynamic code generation techniques that facilitate quick and efficient resolution of multi-dimensional data demands. The system includes an object store that stores a first object that references multi-dimensional data and an object model that receives a request for multi-dimensional data referenced by the first object. The object model causes the first object to dynamically generate a portion of the executable software instructions for a second object in response to the request and instantiate the second object within the object store. The dynamically generated portion of the instructions enables the second object to calculate a memory address into the multi-dimensional data referenced by the first object. The second object utilizes the dynamically generated portion of the instructions to satisfy the request. Because the second object maintains direct access to the multi-dimensional data, it need not make costly and time consuming function calls to the first object.

Abstract: Techniques are described for sharing multidimensional data between software systems, such as enterprise software systems. Specifically, the techniques provide mechanisms for defining inter-application “links” for automatically moving data among different databases associated with the enterprise software systems. For example, a system may include a first database storing multidimensional data for a first software application, and a second database storing multidimensional data for a second software application. The system further includes an interface by which an administrator defines a link that specifies a source area of the first database and a target area of the second database. A link control module automatically moves multidimensional data from the source area to the target area in accordance with the link. The link control module may automatically move the multidimensional data directly between live portions of the respective databases.

Abstract: The present invention is directed to a business intelligence monitor method and system. Business intelligence indicators are monitored by generating a monitoring repository through selecting functions from a collection of functions, for receiving the business intelligence indicators as inputs. The thresholds for the business intelligence indicators are then established to define the states for the business intelligence indicators. Each state of the business intelligence indicators is assigned an associated priority. The monitoring repository is updated by retrieving a current value for each of the business intelligence indicators from a data source, thereby determining the state for each of the business intelligence indicators based on the current value. A report based on the updated monitoring repository is then created.

Abstract: An enterprise software system provides an innovative double dispatch data retrieval technique that facilitates determining type safety during compile-time. The system includes an object store for storing a multi-dimensional dataset object. The dataset object provides an interface having a first function for instantiating a non-type-specific indexer object and a second function that returns a type-specific value of the plurality of data element currently referenced by the indexer object. The system also includes an object model that stores the dataset object to the object store, invokes the first function to instantiate the indexer object within the object store, utilizes the indexer object to reference the data element of the dataset object, and invokes the second function to retrieve the type-specific value of the data element referenced by the indexer object. Because the dataset provides the second method by which a type-specific value is returned, compilers may quickly determine type-safety concerns.

Abstract: An enterprise planning and performance management system provides a variable-based modeling technique that enables users to interact with a more manageable variable-centric front-end for complex enterprise planning software. The system enables users to specify a plurality of variable definitions via a variable-based user interface. Based on the plurality of variable definitions, the system generates, and in some instances automatically generates, model data that defines an enterprise planning model. The system uses the model data during subsequent enterprise planning sessions. Because model builders typically comprise financial analysts unfamiliar with traditional complex enterprise modeling techniques but familiar with common financial variables of an enterprise, this variable-based modeling technique may facilitate easier model building by allowing these financial analysts to generate model data from the perspective of the more readily understood variables.

Abstract: Techniques are described of entering and presenting data in an enterprise planning and performance management system. As disclosed herein, the techniques facilitate the capture and entry of data into an underlying multidimensional dataset through action-based forms. In addition, the techniques allow reviewers to use spreadsheet-like views of the captured data. In certain embodiments, the techniques also facilitate straightforward review of changes to data within the spreadsheet-like views by providing a task log that enables reviewers to more readily review, accept, or dismiss such changes.

Abstract: 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.

Abstract: The invention provides improved mechanisms for the construction and rendering of graphical results sets for business intelligence reports derived from large volumes of data. This is achieved by various means including, determining the amount of useful data that can be rendered within the available display space while still being legible, determining the most effective way of displaying that data within the display space, and providing for limited control of the format and quantity of data displayed.

Abstract: A system and method for representing a very large dataset that enables a plan manager to define, based upon an organization modelling object, a delegation modelling object for a very large dataset. A very large dataset delegation of multiple subplans is created whose subplans can then be individually filtered for specific size restrictions. This enables a plan manager to filter the definition of each subplan prior to the execution of the delegation modelling object, precluding any need for higher-level subplans to contain all the data contained in their subordinate subplans. This allows subplans to contain increased levels of detail not included in their superior subplans, detail that will instead only be summarized in higher-level subplans. A subsequent consolidation process will then extract data not found at higher levels from each delegated subplan, and return that data to its original dataset.

Abstract: A method and system for mapping datasources in a metadata model that provides datasource connections that are structurally isolated from the metadata model and which incorporate physical datasource addressing information for mapping a logical datasource structured within the metadata model to a particular physical datasource “on-the-fly”, and in a run-time environment. In an embodiment of the present invention, security can be implemented to limit user access leveraging an organization's security regime.

Abstract: A chart data layout system and method of processing chart data in a report is provided. The chart data layout system comprises a query module for decomposing required data into required data queries, a chart layout module for rendering a chart based upon chart data received from the queries, a category module for displaying category aggregate information in a category location of a chart, and a series module for displaying series aggregate information in a series location of the chart. The method comprises the steps of decomposing required data into queries, retrieving queried data, rendering a chart based upon the queried data, rendering category information on a category label of the chart based upon queried data, and rendering series information on a series label of the chart based upon queried data.

Abstract: 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.

Abstract: A member unique name (MUN) structure and MUN translation system and method are provided. The MUN structure comprises a canonical business key for uniquely identifying a member across different dimensional data sources within a business enterprise and at least one of a dimension reference for defining the context in which the remaining portions of the MUN exist or a data source identifier (DSI) for uniquely identifying a member within a dimensional data source that implements its own unique member identifiers. The MUN translation system comprises a translation selection module for selecting a MUN transformation and a collection of MUN transformations for transforming a MUN structure of a first data source into a MUN structure of the second data source.

Abstract: 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.