Problem processing a dimension | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem processing a dimension

Hi, The underlying table for my Customer Dimension has these fields: CustCode, CustName, CustSateId, CustCityId, CustTypeId, CustSubTypeId I have some customers who have branches in different States and or cities. For such customers the name ofcourse is the same but the CustCode is different. And depending, CustStateId and/or CustCityId are also different. For example CustCode, CustName, CustSateId, CustCityId
1, ABC, 1, 1
2, ABC, 1, 2

81, XYZ, 5, 3
82, XYZ, 9, 1 Hoping that my post is clear so far…. I changed that way I was making my Customer dimension (after coming across an article) and defined the Member Key Column as the CustCode field and Member Name Column as the CustName field. But when I process my cube I get an error that "Detected two siblings with the same Name…….." I have tried playing with changing the Member Names Unique property but the error is still there. BTW, previosuly I was using the CustName field as the Member Key column also and was not getting any error. Was this a bad approach or a correct approach? Is this a design problem? Is this a common problem? Any clues about how to solve such a problem. Many TIA.

]]>