Patent ID: 8255368

Claim:
A non-transitory computer readable storage medium, comprising executable instructions to: receive user-created data with user-specified positions in a pre-existing OLAP hierarchy, wherein the OLAP hierarchy comprises members arranged in position specified by an OLAP server, wherein the user-created data with user-specified positions in the OLAP hierarchy is expressed as a multidimensional expression listing the user-created data relative to user-created data siblings to the left and right of the user created data, the user-specified positions differing from positions that would have been specified by the OLAP server absent the user-created data, wherein the user-created data is received via a graphical user interface displayed to a user for defining user-created data at the user-specified positions in the OLAP hierarchy and adding the user-created data to the OLAP hierarchy at server-specified positions; generate data manipulation statements to insert the user-created data in user-specified positions of the OLAP hierarchy, wherein the user-specified positions specify lineage of the user-created data and order of the user-created data relative to the user-created data siblings; and rearrange the OLAP hierarchy to reposition the user-created data from the server-specified positions into the user-specified positions.