Automatically moving annotations associated with multidimensional data between live datacubes
First Claim
1. A method for exporting data from a first enterprise software system comprising:
- defining a link from the first enterprise software system to a second enterprise software system, wherein the link specifies a source area of a first multidimensional database and a target area of a second multidimensional database, wherein the link defines one or more of mappings each specifying a relationship between one or more cells of the source area and one or more cells of the target area, wherein the first enterprise software system accesses the first multidimensional database, wherein the second enterprise software system accesses the second multidimensional database, and wherein the first and second multidimensional databases each include three or more dimensions;
automatically copying multidimensional data from the source area of the first multidimensional database to the target area of the second multidimensional database in accordance with the link;
identifying one or more annotations associated with the multidimensional data of the source area, wherein each of the annotations defines at least text-based commentary associated with a portion of the multidimensional data of the source area; and
automatically copying the identified one or more annotations associated with the multidimensional data of the source area from the source area to the target area in accordance with the link, wherein automatically copying includes;
if the link defines a first mapping of the plurality of mappings from one cell of the source area to a plurality of cells of the one or more cells of the target area and at least one of the one or more annotations is associated with the one cell of the source area, replicating the at least one annotation associated with the one cell of the source area into multiple annotations, and associating each of the multiple annotations with a respective cell of the plurality of cells of the target area andif the link defines a second mapping of the plurality of mappings from a plurality of cells of the one or more cells of the source area to one cell of the target area and each of at least two of the one or more annotations are associated with a respective cell of the plurality of cells of the source area, associating the at least two annotations with the one cell of the target area.
4 Assignments
0 Petitions
Accused Products
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.
-
Citations
24 Claims
-
1. A method for exporting data from a first enterprise software system comprising:
-
defining a link from the first enterprise software system to a second enterprise software system, wherein the link specifies a source area of a first multidimensional database and a target area of a second multidimensional database, wherein the link defines one or more of mappings each specifying a relationship between one or more cells of the source area and one or more cells of the target area, wherein the first enterprise software system accesses the first multidimensional database, wherein the second enterprise software system accesses the second multidimensional database, and wherein the first and second multidimensional databases each include three or more dimensions; automatically copying multidimensional data from the source area of the first multidimensional database to the target area of the second multidimensional database in accordance with the link; identifying one or more annotations associated with the multidimensional data of the source area, wherein each of the annotations defines at least text-based commentary associated with a portion of the multidimensional data of the source area; and automatically copying the identified one or more annotations associated with the multidimensional data of the source area from the source area to the target area in accordance with the link, wherein automatically copying includes; if the link defines a first mapping of the plurality of mappings from one cell of the source area to a plurality of cells of the one or more cells of the target area and at least one of the one or more annotations is associated with the one cell of the source area, replicating the at least one annotation associated with the one cell of the source area into multiple annotations, and associating each of the multiple annotations with a respective cell of the plurality of cells of the target area and if the link defines a second mapping of the plurality of mappings from a plurality of cells of the one or more cells of the source area to one cell of the target area and each of at least two of the one or more annotations are associated with a respective cell of the plurality of cells of the source area, associating the at least two annotations with the one cell of the target area. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A system comprising:
-
a programmable processor; a first database storing multidimensional data accessible at least by a first enterprise software system, wherein the multidimensional data of the first database includes three or more dimensions; a second database storing multidimensional data accessible at least by a second enterprise software system, wherein the multidimensional data of the second database includes three or more dimensions; an interface to receive input that defines a link specifying a source area of the first database and a target area of the second database, wherein the link defines one or more mappings each specifying a relationship between one or more cells of the source area and one or more cells of the target area; and a link control module executable by the programmable processor to; automatically copy multidimensional data from the source area to the target area in accordance with the link; identify one or more annotations associated with the multidimensional data of the source area, wherein each of the annotations defines at least text-based commentary associated with a portion of the multidimensional data of the source area; and automatically copy the identified one or more annotations associated with the multidimensional data of the source area from the source area to the target area in accordance with the link, wherein automatically copying includes; if the link defines a first mapping of the plurality of mappings from one cell of the source area to a plurality of cells of the one or more cells of the target area and at least one of the one or more annotations is associated with the one cell of the source area, replicating the at least one annotation associated with the one cell of the source area into multiple annotations, and associating each of the multiple annotations with a respective cell of the plurality of cells of the target area and if the link defines a second mapping of the plurality of mappings from a plurality of cells of the one or more cells of the source area to one cell of the target area and each of at least two of the one or more annotations are associated with a respective cell of the plurality of cells of the source area, associating the at least two annotations with the one cell of the target area. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22)
-
-
23. A computer-readable hardware storage medium comprising instructions that cause one or more programmable processors of a computing device to:
-
present a user interface to receive input specifying a link defining; a source data cube of a first enterprise software system, the source data cube including three or more dimensions, a source dimension of the source data cube, a target data cube of a second enterprise software system, the target data cube including three or more dimensions, a target dimension of the target data cube, and one or more mappings each specifying a relationship between one or more cells of the source data cube and one or more cells of the target data cube; automatically copy multidimensional data associated with the source item of the source data cube to the target items of the target data cube; identify one or more annotations associated with the multidimensional data of the source data cube, wherein each of the annotations defines at least one text-based commentary associated with a portion of the multidimensional data of the source data cube; and automatically copy the identified one or more annotations associated with the multidimensional data of the source data cube from the source data cube to the target data cube in accordance with the link, wherein automatically copying includes; if the link defines a first mapping of the plurality of mappings from one cell of the source data cube to a plurality of cells of the one or more cells of the target data cube and at least one of the one or more annotations is associated with the one cell of the source data cube, replicating the at least one annotation associated with the one cell of the source data cute into multiple annotations, and associating each of the multiple annotations with a respective cell of the plurality of cells of the target data cube; and if the link defines a second mapping of the plurality of mappings from a plurality of cells of the source data cube to one cell of the target data cube and each of at least two of the one or more annotations are associated with a respective cell of the plurality of cells of the source data cube, associating the at least two annotations with the one cell of the target data cube. - View Dependent Claims (24)
-
Specification