Category Generation has quit

[cognos05]

Hi,
I am new to transformer and learning with a small sample data.

Have built time dim using date wizard and works fine.
Have built a location dimension which has data like

Data for location dimension with levels all region->Region->City->REPID
All Regions^East^Miami^1235
All Regions^West^NewJersey^1236
All Regions^West^NewJersey^1237
All Regions^East^Naples^1248
All Regions^East^Miami^1249
All Regions^East^Naples^1234

Now my transactional data looks like

City^REPID^Months^Sales
Naples^1234^Aug-14^5000
Miami^1235^Sep-14^2500
NewJersey^1236^Sep-14^2500
NewJersey^1237^Oct-14^4500
Naples^1248^Oct-14^4500
Miami^1249^Nov-14^5600
Naples^1234^Nov-14^4750
Miami^1249^Nov-14^15000

Here I am getting an error while building the cube like Category generation has quit in row 4 of data source. transformer could not create a ctegory with the source value 'NewJersey' in the dimension Location.


I have already marked my rep id as unique and move.
If I mark my City level as also unique then there is no error.

Why should I mark my city as unique, its not the lowest level right , a city can contain various reps right?

Anyone please explain.

Thanks,
Nithya

[bdbits]

It seems to me you might not actually have a unique single column key on your location table. The uniqueness is a combination of at least city and rep id.

I think.