• cook155 (4/21/2014)


    Jeff, Would that mean i made an extra attribute and need to delete it? How do i do that?

    You don't need to delete any data. The 'duplicate' you are encountering is because your Calendar Quarter attribute likely uses only the CalendarQuarter column from your Date dimension as a Key column. Analysis Service doesn't know that Quarter 1 of 2013 is distinct from Quarter 1 of 2014, hence the error.

    What you need to do is define a composite key as the Key column for your Calendar Quarter attribute and, most commonly, the combination of Year and Quarter is used, e.g. 2013Q1 and 2014Q1. Now Analysis Services sees those as distinct values (as indeed they are of course) and your Dimension processing errors disappear (or at least that one does ;-)).

    Regards

    Lempster