I have a regular dimension based on a
table named "DIM_bank". I want
the dimension to aggregate on
only one level (on the key "code").
The problem is that when I add
the attribute for "location", it
uses the last "location" alphabetically
for a given "code". It does not
use the most current "location"
as desired. Any ideas how to
fix?

PS. Below is the structure and
sample data of the dimension. Dimension
records are added to table "DIM_bank"
using the "type 2 slowly changing"
algorithm from Kimball.




Table: DIM_bank
Fields: ...
surrogate_key (int),
code (char),
name (char),
location (char),
location_changed_date (datetime)


10;"BOA";"Bank of Atest";"Chicago, IL";1/1/2003
20;"BOA";"Bank of Atest";"New York, NY";2/1/2003
30;"BOA";"Bank of Atest";"Atlanta, GA";3/1/2003