In accordance with an embodiment, described herein are systems and methods for enabling multiple parents with weights in a multidimensional database. An exemplary system can comprise 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. A data dimension can comprises a plurality of members, a first set of members being a first level, and a second set of members being at a second level. A member of the second set of members at the second level can comprises two or more member-member relationships with two or more members of the first set of members at the first level. Each of the two or more member-member relationships are associated with a weight.