Unanswered: A query about member groups in MS Olap
I tried to create a member group in a dimension .Say dimension name is loc and having levels as country, state, city (top most level is country).We know that members of the level used to create member groups must have unique names. Set the Member Names Unique property to True for the level in Dimension Editor or Cube Editor before you create member groups. My question is if I add a new level below country but immediately above state why is it customary to have Member names unique property to be true for both state and city level? I first tried to set the said property to be true only for state level but encountered with an error message saying Member Names Unique property must be True When I have set the said property to be true for both state and city levels the error was removed and it worked perfectly fine.