-
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........"
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|