Data entry commentary and sheet reconstruction for multidimensional enterprise system

• US 9,268,837 B2
• Filed: 12/04/2007
• Issued: 02/23/2016
• Est. Priority Date: 12/04/2007
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hodge, Johnathan, Ballantine, Peter Roy, Conic, Sasa
• Primary Examiner(s): Hu, Jensen
• Application Number:
  US11/950,257
• Publication Number:
  US 20090144313A1
• Time in Patent Office: 3,003 Days
• Field of Search: 707/1, 707/796, 707/999.001
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2264 Multidimensional index structures
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 40/134 Hyperlinking
• CPC Class Codes: G06F 40/169 Annotation, e.g. comment data or footnotes

Abstract

A computing device is described that includes a user interface to receive contribution data of an enterprise and to display a sheet of the contribution data, an annotation interface module to receive one or more annotations for objects of the contribution data, a planning application to retrieve a context definition defining a context in which each of the annotations was received, and an annotation table to store each of the annotations and the context definition corresponding to each of the annotations. The user interface may be configured to output the annotations. The computing device may improve the collaborative process of developing multidimensional data. Users of the computing device may quickly and easily share their thoughts, questions, and comments about the data through annotations. Recreating an annotated sheet may be done efficiently by storing relevant coordinates.

Claims

1. A method comprising:

receiving contribution data of an enterprise in accordance with a multi-level enterprise model;

storing the contribution data within a database, wherein the database comprises a multidimensional database comprising N dimensions, and wherein N is greater than two;

receiving a first annotation for a first object of the contribution data;

retrieving a first context definition defining a first context in which the first annotation was received, wherein the context corresponds to a particular cell of a sheet of the multidimensional database comprising full versions of two of the N dimensions and single values for each of the remaining N dimensions;

receiving a second annotation for a second object corresponding to a second context, the second object including the particular cell and being a higher-order object than the particular cell;

storing the first annotation, the second annotation, the first context definition, and the second context definition that defines the second context in which the second annotation was received; and

outputting, based on the first and second context definitions, the first annotation and the second annotation in a graphical user interface.

2. The method of claim 1, further comprising

retrieving coordinates defining the first object within the first context definition,

wherein storing further comprises storing the coordinates.

3. The method of claim 1, wherein outputting comprises displaying the first annotation and the second annotation to a user.

4. The method of claim 1, further comprising outputting a link to the first context defined by the first context definition.

5. The method of claim 4, further comprising, when the first link is selected, outputting the sheet according to the first context definition.

6. The method of claim 1, further comprising receiving a request to delete at least one of the first annotation or the second annotation.

7. The method of claim 6, further comprising removing at least one of the first annotation or the second annotation from storage according to the received request.

8. The method of claim 1, wherein storing the first annotation, the second annotation, the first context definition, and the second context definition comprises storing the first annotation, the second annotation, the first context definition, and the second context definition in the database.

9. The method of claim 1, wherein at least one of the first annotation or the second annotation includes at least one of a user identifier, a date indicator, a value indicator, a comment, or an attached file.

10. The method of claim 1, further comprising:

receiving a plurality of different annotations for a single cell of data of a worksheet, wherein outputting comprises outputting the plurality of annotation in the order in which the annotations were received.

11. A tangible computer-readable storage medium comprising instructions for causing a programmable processor to:

receive contribution data of an enterprise in accordance with a multi-level enterprise model;

store the contribution data within a database, wherein the database comprises a multidimensional database comprising N dimensions, and wherein N is greater than two;

receive a first annotation for a first object of the contribution data;

retrieve a first context definition defining a first context in which the first annotation was received, wherein the context corresponds a particular cell of to a sheet of the multidimensional database comprising full versions of two of the N dimensions and single values for each of the remaining N dimensions;

receive a second annotation for a second object corresonding to a second context, the second object including the particular cell and being a higher-order object than the particular cell;

store the first annotation, the second annotation, the first context definition, and the second context definition that defines the second context in which the second annotation was received; and

display, based on the first and seond context definitions, the first annotation and the second annotation to a user in a graphical user interface.

12. The tangible computer-readable storage medium of claim 11, further comprising instructions to:

retrieve coordinates identifying the first object within the first context definition, and

store the coordinates.

13. The tangible computer-readable storage medium of claim 11, further comprising instructions to:

output a link to the first context defined by the first context definition, and

output the sheet according to the first context definition when the link is selected.

14. The tangible computer-readable storage medium of claim 11, further comprising instructions to:

receive a request to delete at least one of the first annotation or the second annotation,

and

remove at least one of the first annotation or the second annotation from storage according to the received request.

16. The method of claim 14, further comprising outputting the sheet in accordance with at least one of the first or second context definitions when the link is selected.

17. The method of claim 14, further comprising storing the first annotation in an annotation table.

15. A method comprising:

retrieving contribution data from an enterprise system, wherein the contribution data is arranged in N dimensions, and wherein N is greater than two;

retrieving first and second annotations for first and second objects of the contribution data from the enterprise system;

retrieving first and second context definitions defining first and second contexts in which the first and second annotations were entered, wherein the first context corresponds to a cell of a sheet representative of the contribution data, the sheet comprising full versions of two of the N dimensions and single values for each of the remaining N dimensions, the cell included in a higher-order object than the cell, the second context corresponding to the higher-order object;

generating a link to at least one of the first or second context defined by the first or second context definitions; and

outputting the link.

18. A computing device comprising:

a user interface to receive contribution data of an enterprise and to display a sheet of the contribution data, wherein the contribution data is arranged in N dimensions, wherein N is greater than two, and wherein the sheet comprises full versions of two of the N dimensions and single values for each of the remaining N dimensions;

an annotation interface module to receive a first annotation for a first object of the contribution data and a second annotation for a second object;

a planning application to retrieve a first context definition defining a first context in which the first annotation was received, wherein the context definition corresponds to a particular cell of the sheet of the contribution data;

where the user interface receives a second annotation for a second object corresponding to a second context, the second object including the particular cell and being a higher-order object than the particular cell; and

an annotation table to store the first annotation, the second annotation, the first context definition, and the second context definition, that defines the second context in which the second annotation was received; and

wherein the user interface is configured to output, based on the fist and second context definitions, the first and second annotations.

19. The computing device of claim 18,

wherein the annotation interface module is configured to receive at least two annotations for one of the first object or the second object of the contribution data within the same context,

wherein the planning application is configured to retrieve coordinates defining the one of the first object and the second object within the context definition, and

wherein the annotation table is configured to store the coordinates.

20. The computing device of claim 18, wherein at least one of the first and second annotations includes at least one of a user identifier to identify a user who entered the annotation, a date identifier to identify the date on which the annotation was entered, a value indicator to identify the value of the object for the at least one of the first and second annotations at the time the at least one of the first and second annotations was entered, a comment field to present a comment from the user who entered the annotation, or an attached file.

21. The computing device of claim 18, further comprising a commentary browser to output a link to at least one of the first context or second context defined by at least one of the first context definition or second context definition for the at least one of the first or second annotations.

22. The computing device of claim 21, wherein the planning applications is configured to instruct the user interface the generate the sheet defined by the at least one of the first context or second context associated with the link when the link is selected.