System and method for enabling multiple parents with weights in a multidimensional database environment

A system for enabling multiple parents with weights in a multidimensional database, comprising:

• a computer that includes one or more microprocessors;
• and
• a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions;
• wherein the hierarchical structure of data dimensions comprises a plurality of members, the plurality of members comprising a first set of members being at a first level and a second set of members being at a second level;
• wherein a member of the second set of members at the second level comprises two or more member-member relationships with two or more members of the first set of members at the first level;
• and
• wherein each of the two or more member-member relationships are associated with a weight of a plurality of weights.

A non-transitory computer readable storage medium having instructions thereon for enabling multiple parents with weights in a multidimensional database, which when read and executed cause a computer to perform steps comprising:

• providing a multidimensional database server executing on a computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions;
• providing, within the hierarchical structure of data dimensions, a plurality of members comprising at least a first set of members being at a first level and a second set of members being at a second level, wherein a member of the second set of members at the second level comprises two or more member-member relationships with two or more members of the first set of members at the first level;
• and
• associating each of the two or more member-member relationships with a weight of a plurality of weights.