Sorry but for privacy reasons I can't upload an example. I attach three screenshots with the different results.
To be sure that there isn't a miss match with the KML I used Left Keep to my facts table to be sure that I only load the ZipCodes that appear in my model. Now I see the same part of the map, not the entire map, but with blank polygons corresponding to ZipCodes that doesn't exist in my model.
Map1.png: Is my target. I only see this map if I load the table as an island.
Map2.png: Is the result of join the island table to my model using ZipCode as a Keyfield.
Map3.png Is the map using Left Keep to my facts table. As you can see there are a few blank regions, these are the regions that aren't in my model.
Thank's a lot for your help!
Hi Ralf and Gysbert,
I've figure out a solution.
First of all I doubled the field ZipCode. Then, I create my map adding my Area and, as dimension, I used the field that is not the keyfield.
It seems that the object is not working if we use a Keyfield which is appears several times in the fact table.
Here's the example:
Load Num(City.Name,'00000') as ZipCode,
Num(City.Name,'00000') as ZipCodeDesc
City.Area as Area
(kml, Table is [City/City])
Load Num(ZipCode,'00000') as ZipCode,
(Field1 to N)
From MySource.qvd (qvd);
Add Area field and ZipCodeDesc as a Dimension.
Thank's for all the help.