Hi,



I have a Dimension Table (Star Schema ) with around 685000 rows.

The dimension contains 6 levels



- Corporate Name

- Company

- Area

- Region

- Terminal

- Load No.





I need to create a Level for Automatic Grouping of Load No.

When I process such a dimension. It gives an error stating

" Found two sibling members having the same name "



I have ensured that the Load Nos for a Given Terminal are all

unique. (They are not unique across Terminal i.e a Load No

occurs in more than one Terminal )



I have set the following Properties for the Level as



Member Keys Unique : True

Member Names Unique : True



If anyone know why this is happening, please let me know.





Regards


--
Posted via http://dbforums.com