Hi,

I need to process a dimension that has 3 levels. Among the 3 rd level, the
member keys are unique and the member names / descriptions are not.

i wouldlike to know if there is a way to process this dimension in MSAS
2000. I set the following at the dimension level.

Member Keys Unique - True
Member Names Unique - False
Allow duplicate names - True.

I still get error upon processing saying that 2 siblings have the same name.

Any ideas?

Thanks,

Sam

You cannot have two siblings with the same name. Names don't have to be
unique in the level, but they cannot have the same parent. You can have:

USA.WA.REDMOND and USA.CA.REDMOND

but you cannot have two members with the name USA.WA.REDMOND . . . how could
such a system work when you cannot differeniate two members which have
EXACTLY the same name up the hierarchy.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote