Hi,

I have a cube with BUs as one of its dimensions. When I process the
cube as Refresh Data the following error comes up:

Processing error [The dimension member key is not unique] 'Desa-NO COST
CENTER (Month)'
However, the Full Process option processes successfully.

Would really appreciate any insight to this problem..I also see a
strange thing here. 'Desa-NO COST CENTER' is the name of a CostCenter
and not Month(howerver month is a level of a diff dim)!
What is the reason behind this ???

The structure of this dimension is as follows:
Two tables are used in populating this dimension.
BusinessUnitOperatingcompany (BUOC)and CostCenter(CC)

Dimension: BUs
Level 1: BUName(member key and member name are BUName :BUOC table)
Level 2: OCName(member key and member name are OCName : BUOC table)
Level 3: CostCenterName(member key = BusinessID and member name =
Costcentername :CC table)

Dimension property:Allow Duplicate Members= True
CostCenterName level property: Member keys unique = True

All the remaining properties have the default values.

Thanks in advance!