Enhanced mechanisms for managing multidimensional data
An enhanced multidimensional data management system significantly reduces the resources required to convert a spreadsheet into an enterprise collaborative system. A spreadsheet may be imported as is without modifications. Additional information that cannot be automatically inferred about the data model used in the spreadsheet is obtained. Dimensions, timescale, and measure data are clearly defined and located. The spreadsheet is kept in the system in the form of both a spreadsheet and as a multidimensional data structure such as an online analytical processing (OLAP) cube or structure. This duality allows the spreadsheet to be manipulated as if it was an OLAP cube, modifying iterations within the dimensions, and the OLAP cube to be computed as if it was a spreadsheet.
1 . A method comprising:
importing a non-collaborative spreadsheet into an enhanced multi-dimensional data management system (EMDMS), wherein the non-collaborative spreadsheet is a spreadsheet that is originally without collaborative capabilities;
bi-directionally mapping the non-collaborative spreadsheet into an EMDMS spreadsheet and an online analytical processing (OLAP) structure, wherein the EMDMS spreadsheet is a spreadsheet that includes collaborative capabilities including an ability to support many different users working together on a same spreadsheet at a same time; and
maintaining a bi-directional mapping between the EMDMS spreadsheet and the OLAP structure, wherein upon receiving an EMDMS spreadsheet change, the EMDMS spreadsheet is modified according to the EMDMS spreadsheet change and the OLAP structure is modified according to the bi-directional mapping, and wherein upon receiving an OLAP change, the OLAP structure is modified according to the OLAP change and the EMDMS spreadsheet is modified according to the bi-directional mapping.
2 . The method of claim 1 , wherein the non-collaborative spreadsheet further lacks version management capabilities.
3 . The method of claim 1 , wherein the non-collaborative spreadsheet does not track when a cell is modified.
4 . The method of claim 1 , wherein modifying iterations to dimensions/measures/timescale in the OLAP structure modifies rows/columns in the EMDMS spreadsheet along with corresponding formulas.
5 . The method of claim 1 , wherein the EMDMS spreadsheet includes a mode where cells that belong to a dimension/time axis/set of measures are colored.
6 . The method of claim 1 , further comprising receiving modifications to the non-collaborative spreadsheet, wherein the modifications to the non-collaborative spreadsheet are propagated as modifications to the OLAP structure.
7 . The method of claim 1 , wherein an enterprise collaborative system is configured to export modifications to the non-collaborative spreadsheet.
8 . The method of claim 1 , further comprising updating the OLAP structure during re-import of the non-collaborative spreadsheet.
9 . A system comprising:
an interface configured to import a non-collaborative spreadsheet into an enhanced multi-dimensional data management system (EMDMS), wherein the non-collaborative spreadsheet is a spreadsheet that is originally without collaborative capabilities;
a processor configured to bi-directionally map the non-collaborative spreadsheet into an EMDMS spreadsheet and an online analytical processing (OLAP) structure, wherein the EMDMS spreadsheet is a spreadsheet that includes collaborative capabilities including an ability to support many different users working together on a same spreadsheet at a same time; and
storage configured to maintain the EMDMS spreadsheet and the OLAP structure, wherein the EMDMS spreadsheet and the OLAP structure is bidirectionally mapped, wherein upon receiving an EMDMS spreadsheet change, the EMDMS spreadsheet is modified according to the EMDMS spreadsheet change and the OLAP structure is modified according to the bi-directional mapping, and wherein upon receiving an OLAP change, the OLAP structure is modified according to the OLAP change and the EMDMS spreadsheet is modified according to the bi-directional mapping.
10 . The system of claim 9 , wherein the non-collaborative spreadsheet further lacks version management capabilities.
11 . The system of claim 9 , wherein the non-collaborative spreadsheet does not track when a cell is modified.
12 . The system of claim 9 , wherein modifying iterations to dimensions/measures/timescale in the OLAP structure modifies rows/columns in the EMDMS spreadsheet along with corresponding formulas.
13 . The system of claim 9 , wherein the EMDMS spreadsheet includes a mode where cells that belong to a dimension/time axis/set of measures are colored.
14 . The system of claim 9 , further comprising receiving modifications to the non-collaborative spreadsheet, wherein the modifications to the non-collaborative spreadsheet are propagated as modifications to the OLAP structure.
15 . The system of claim 9 , wherein an enterprise collaborative system is configured to export modifications to the non-collaborative spreadsheet.
16 . The system of claim 9 , further comprising updating the OLAP structure during re-import of the non-collaborative spreadsheet.
17 . The system of claim 9 , wherein a plurality of non-collaborative spreadsheets are modified at a plurality of client devices.
18 . A non-transitory computer readable medium comprising:
computer code for importing a non-collaborative spreadsheet into an enhanced multi-dimensional data management system (EMDMS), wherein the non-collaborative spreadsheet is a spreadsheet that is originally without collaborative capabilities;
computer code for bi-directionally mapping the non-collaborative spreadsheet into an EMDMS spreadsheet and an online analytical processing (OLAP) structure, wherein the EMDMS spreadsheet is a spreadsheet that includes collaborative capabilities including an ability to support many different users working together on a same spreadsheet at a same time; and
computer code for maintaining a bi-directional mapping between the EMDMS spreadsheet and the OLAP structure, wherein upon receiving an EMDMS spreadsheet change, the EMDMS spreadsheet is modified according to the EMDMS spreadsheet change and the OLAP structure is modified according to the bi-directional mapping, and wherein upon receiving an OLAP change, the OLAP structure is modified according to the OLAP change and the EMDMS spreadsheet is modified according to the bi-directional mapping.
19 . The non-transitory computer readable medium of claim 18 , wherein the non-collaborative spreadsheet further lacks version management capabilities.
20 . The non-transitory computer readable medium of claim 18 , wherein the non-collaborative spreadsheet does not track when a cell is modified.