Various technologies and techniques are disclosed for creating and managing a visual representation of OLAP attributes and relationships for a dimension. A visual representation is generated that contains an arrangement of shapes with connections between shapes. One or more sub-elements are contained within at least some of the shapes. Connections between the shapes represent relationships between attributes in an OLAP dimension. The containment of a respective sub-element within a respective shape represents a relationship between an attribute being represented by the respective sub-element and an attribute being represented by the respective shape. Shapes representing OLAP attributes and relationships can be programmatically grouped and ungrouped. When an attribute does not have any outgoing relationships, when an attribute only has one incoming relationship, and when the attribute is not a level in a user-defined hierarchy, a grouping process is performed to put the attribute in an expandable shape belonging to another attribute.
Legal claims defining the scope of protection, as filed with the USPTO.
1. A method for creating a visual representation of OLAP attributes and relationships for a dimension comprising the steps of: generating a visual representation that contains an arrangement of shapes with connections between the shapes, with one or more sub-elements contained within at least some of the shapes, with the connections between the shapes representing relationships between attributes in an OLAP dimension, and with the containment of a respective sub-element within a respective shape representing a relationship between an attribute being represented by the respective sub-element and an attribute being represented by the respective shape; displaying a textual list of attributes that corresponds to the attributes shown in the visual representation; and when a respective attribute is selected in the textual list, visually indicating a corresponding attribute on the visual representation.
2. The method of claim 1 , further having computer-executable instructions for causing a computer to perform steps comprising: displaying the visual representation on a display device.
3. The method of claim 2 , wherein the shapes are initially displayed in a collapsed state when the visual representation is displayed on the display device.
4. The method of claim 1 , further having computer-executable instructions for causing a computer to perform steps comprising: receiving a save layout selection; saving a position of each of the shapes and connections; and saving a state of each shape.
5. The method of claim 4 , wherein the save layout selection is received from a user.
6. The method of claim 4 , wherein the save layout selection is received programmatically.
7. The method of claim 1 , further comprising the steps of: receiving a selection to arrange a layout of the visual representation.
8. The method of claim 7 , further comprising the steps of: preserving a state of each of the shapes; and removing any shape overlap between the shapes.
9. The method of claim 8 , further comprising the steps of: moving any orphaned shapes to an orphan zone.
10. The method of claim 8 , further comprising the steps of: updating the visual representation.
11. The method of claim 1 , further comprising the steps of: receiving a selection to expand the visual representation; processing each of the shapes and expanding the shapes to show all of the attributes; and updating the visual representation to show all shapes in an expanded state.
12. The method of claim 1 , further comprising the steps of: receiving a selection to collapse the visual representation; processing each of the shapes and collapsing the shapes to hide any attributes that are sub-elements; and updating the visual representation to show all shapes in a collapsed state.
13. A method for programmatically grouping and ungrouping shapes in a visual representation of OLAP attributes and relationships comprising the steps of: when an attribute does not have any outgoing relationships, when an attribute only has one incoming relationship, and when the attribute is not a level in a user-defined hierarchy, performing a grouping process to put the attribute in an expandable shape belonging to another attribute in a visual representation of OLAP attributes and relationships.
14. The method of claim 13 , further comprising the steps of: when an outgoing relationship is added for the attribute, performing an ungrouping process to put the attribute in a separate shape.
15. The method of claim 13 , further comprising the steps of: when two or more incoming relationships are present for the attribute, performing an ungrouping process to put the attribute in a separate shape.
16. The method of claim 13 , further comprising the steps of: when the attribute becomes the level in the user-defined hierarchy, performing an ungrouping process to put the attribute in a separate shape.
17. A computer-readable medium having computer-executable instructions for causing a computer to perform steps comprising: receiving input to access a visual representation of OLAP attributes and relationships for a dimension; when the visual representation for the OLAP attributes and relationships has not already been created for the dimension, performing a layout process to create a layout for the visual representation, the layout process comprising the steps of: generating the visual representation in the layout that contains an arrangement of shapes with connections between the shapes, with one or more sub-elements contained within at least some of the shapes, with the connections between the shapes representing relationships between the OLAP attributes in the dimension, and with the containment of a respective sub-element within a respective shape representing a relationship between an attribute being represented by the respective sub-element and an attribute being represented by the respective shape; receiving a selection to expand the visual representation; processing each of the shapes and expanding the shapes to show all of the attributes; and updating the visual representation to show all shapes in an expanded state.
18. The computer-readable medium of claim 17 , further having computer-executable instructions operable to perform steps comprising: when the visual representation for OLAP attributes and relationships has already been created for the dimension, retrieving annotations that were saved a previous time that the visual representation was displayed, the annotations representing settings necessary to re-construct the layout.
19. The computer-readable medium of claim 17 , further having computer-executable instructions operable to perform steps comprising: displaying the visual representation on a display device.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
November 21, 2007
September 27, 2011
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.