A dimension table "DIM_B" is dependant of "DIM_A". Multiple rows in DIM_B has the same name in column "NAME".

The problem is Mondrian merges all rows with duplicate names.

Example of dimensions:

<Dimension foreignKey="DIM_A" name="A" type="StandardDimension">
<Hierarchy primaryKey="ID" name="A" allLevelName="(ALL)" hasAll="true">
<Table name="DIM_A"/>
<Level name="Name" column="ID" nameColumn="NAME" ordinalColumn="NAME" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"/>
</Hierarchy>
</Dimension>

<Dimension foreignKey="DIM_B" name="Operations" type="StandardDimension">
<Hierarchy primaryKey="ID" name="Operation" allLevelName="(ALL)" hasAll="true">
<Table name="DIM_B"/>
<Level name="Name" column="ID" nameColumn="NAME" ordinalColumn="NAME" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"/>
</Hierarchy>
</Dimension>



So two rows can have same name like this:

ID = 11, A = 1, B = 1, Name = "Name1", Value = 1
ID = 12, A = 2, B = 1, Name = "Name1", Value = 1

Would be displayed like this:

Name1, Value 1

But how can the dimensions be configured to show both of these rows? Alternatively, how to show them merged but also summarized values?