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: Methods and apparatus, including computer program products, implementing and using techniques for resolving cell-level access in a multi-dimensional data structure based on one or more sets of dimensional access rules. A business hierarchy is provided with nodes arranged in a tree structure. An online analytical processing database has several data cubes, where at least some have the business hierarchy as one of their dimensions. One or more rule-based access tables are provided for controlling access to cells of each data cube. Groups of nodes with identical access settings are identified in the business hierarchy. A single access block is generated per node group. Each access block is a serializable access specification object that contains information for generating a complete cell-level mask of access settings for a single node of the business hierarchy. The mask is generated based on the information in the access blocks for each node in the hierarchy.

Abstract: Techniques are described for sharing multidimensional data and associated annotations between software systems. As described herein, the techniques provide mechanisms for defining inter-application “links” for automatically copying data and associated annotations among 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 and annotations associated with cells or cubes of the multidimensional data from the source area to the target area in accordance with the link.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for resolving cell-level access in a multi-dimensional data structure based on one or more sets of dimensional access rules. A business hierarchy is provided with nodes arranged in a tree structure. An online analytical processing database has several data cubes, where at least some have the business hierarchy as one of their dimensions. One or more rule-based access tables are provided for controlling access to cells of each data cube. Groups of nodes with identical access settings are identified in the business hierarchy. A single access block is generated per node group. Each access block is a serializable access specification object that contains information for generating a complete cell-level mask of access settings for a single node of the business hierarchy. The mask is generated based on the information in the access blocks for each node in the hierarchy.

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: 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: 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: This disclosure describes techniques of validating data that a user enters into an enterprise system for storage within a multidimensional data cube. The data cube includes one or more data hyperplanes associated with members of a dimension having cells that contain data. In addition, the data cube includes a validation rule hyperplane of the dimension. Cells in the validation rule hyperplane contain data that indicate whether data in corresponding cells of the data hyperplanes comply with a validation rule. In accordance with these techniques, data in the cells of the data hyperplanes may be submitted if the data in the cells of the validation results hyperplane indicate that data contained in corresponding cells of the data hyperplanes complies with the validation rule.

Abstract: Techniques are described for sharing multidimensional data and associated annotations between software systems. As described herein, the techniques provide mechanisms for defining inter-application “links” for automatically copying data and associated annotations among 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 and annotations associated with cells or cubes of the multidimensional data from the source area to the target area in accordance with the link.

Abstract: This disclosure describes techniques of validating data that a user enters into an enterprise system for storage within a multidimensional data cube. The data cube includes one or more data hyperplanes associated with members of a dimension having cells that contain data. In addition, the data cube includes a validation rule hyperplane of the dimension. Cells in the validation rule hyperplane contain data that indicate whether data in corresponding cells of the data hyperplanes comply with a validation rule. In accordance with these techniques, data in the cells of the data hyperplanes may be submitted if the data in the cells of the validation results hyperplane indicate that data contained in corresponding cells of the data hyperplanes complies with the validation rule.

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