SQL Server Performance

Problem processing a dimension

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Mar 16, 2005.

  1. Joozh New Member

    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.

Share This Page