MS SQL Server OLAP - Member key Unique but Member Names not Unique

Author

Member key Unique but Member Names not Unique

Prasad

2005-04-26, 1:23 pm

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

Dave Wickert [MSFT]

2005-04-26, 8:24 pm

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@online.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@discussions.microsoft.com> wrote in message
news:B7197583-82E2-4F70-9D1C- 93D1E6FF899F@microso
ft.com...
> 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
>
>

Sponsored Links