Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-03-16 : 23:05:02
|
| Hi,The underlying table for my Customer Dimension has these fields:CustCode, CustName, CustSateId, CustCityId, CustTypeId, CustSubTypeIdI 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 exampleCustCode, CustName, CustSateId, CustCityId1, 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........"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?I have tried playing with changing the Member Names Unique property but the error is still there.Is this a design problem? Is this a common problem? Any clues about how to solve such a problem. Many TIA. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-17 : 04:14:40
|
| The easiest design to handle is the one where both memberkey + membername are unique. (1:1 correspondance).The problem you got occurs when the same name is duplicated among the children of one parent.Sometimes when we have the type of data you have we do;memberkey : custnbrmembername : custnbr + ' - ' + custnameOften the users find it useful to see the key in combo with the name.It's mostly a design Q, what do we tell AS to use as Key, and what do we present to the users?If they differ in granularity then we have to make sure that the names are at least unique within the children of a level.rockmoose |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-03-17 : 04:22:33
|
| Thanks rockmoose. Your reply helps. |
|
|
|
|
|
|
|
|
Problem when trying to process a Dimension