Hello,

I have big problem with one dimension. It has about
650,000 members, and I always perform incremental
processing on it. Reason for this is that I don't want to
do reprocessing of a cube which references this dimension
because of its size. However, there is one problem that I
wasn't able to solve. After some time of processing, I
started to get this error:

Analysis Server Error: Detected two sibling members with
the same name:

I don't quite understand what it means. The dimension has
3 levels, and this error is about a member on the second
level. I can process the dimension only if I change the
property of the dimension "Allow Duplicate Names" to TRUE.
And this seems to work. However, when I process the cube
related to this dimension some of the members, most
probably those who cause the error message are reported as
not existing in the dimension. This way I loose
information about those members.

Can anyone help me with this problem? I'm really
struggling with this one....Thanx in advance

Regards,
Tibor

Dear Tibor,

Your Solution is quite right.
We cannot guarantee that our member dimension has unique name in one level, even in one parent. Usually, to prevent the error message which is happened to you, people set allow duplicate name property to true (on Advanced Dimension Property), or set member name property to unique name such as concatenation between original member name and member key. For Example, let say Member Name is Product_Name, and Member Key is Product_ID, you can change Member Name to Product_Name + ' - ' + Product_Key (make sure has same data type).

For your case, be careful and be aware, that one parent only can have 64,000 children, so create grouping for level which is could has 64,000 children.

Check BOL for more explanation

Regards,


Nugon

"Tibor" wrote: