I'm using Analysis Service SP3. An example region dimension is as follows

Country State
--------------------
USA USA
USA NULL
....

This is configured as a regular dimension. It can be processed fine with
default settings. However, if I set "Hide member if" to "No name", then I
get the following error:
Detected two sibling members with the same name: USA (State).; Time ...

Obviously I don't have two "USA" at the state level, so what is this error
about?

- Yubo Fan

Hi Yubo,

According to my research, we can try to find the exact error from the
processing log. One issue is processing failing at processing "Currency"
dimension. When we re-structure the shared dimension "Currency", the
processing works fine.

Could you check or post the processing log file?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
e.de!newsfeed.icl.net!newsfeed.fjserv.net!news-out1.nntp.be!propagator2-ster
ling!In.nntp.be!vienna7.his.com!attws1!ip.att.net! lamb.sas.com!newshost!not-
for-mail

I get the following from Query Analyzer. I thought I made myself perfectly
clear. You don't need my data to reproduce the problem. Anything fits in
this pattern would cause the error to occur. I'm just giving out the
simplest example.

Country State
---------------------------------------------------------------- -----------
-----------------------------------------------------
USA NULL
USA USA

(2 row(s) affected)


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Hi Yubo,

I used the following to reproduce the problem:
CREATE TABLE testregion(Country varchar(20), State varchar(20))

insert testregion values('USA',NULL)
insert testregion values('USA','USA')

In Analysis Manager, I create a dimension testregion
Country: Hide Member - Never hidden
State: Hide Member - No name

When I process the dimension, I encounter "Detected two sibling members
with the same name" error. When set the dimension property "Allow Duplicate
Names" to true and re-process, it succeeds.

Then I checked the following:
CREATE TABLE testregion1(Country varchar(20), State varchar(20))

insert testregion values('USA','CA')
insert testregion values('USA','CA')

In Analysis Manager, I create a dimension testregion1
testregion1: "Allow Duplicate Names" - False
Country: Hide Member - Never hidden
State: Hide Member - No name

When I process the dimension, it succeeds. Therefore, the error should
indicate that the parent and child member name is duplicate.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!npeer.de.kpn-eurorings.net!
news-out.nuthinbutnews.com!propagator2-sterling!In.nntp.be!vienna7.his.com!a
ttws1!ip.att.net!lamb.sas.com!newshost!not-for-mail