I have an app based on SQL server tables. In this app I have a master dimension called District, based on the District table, that shows the district name. The District table has 2 fields - ID and Name.
Now I added a KML file to display the districts' polygons on a map. The KML file has Name and Area.
After attaching the kml file to the District table there is a problem with the master dimension. The field for that dimension is no longer available in the app and the graphs show an error. When I open the dimension definitions that field does not exist in the District table. The field District.Name is replaced by DistrictBoundary.Name (the klm file).
In Data Manger I see the District table with the 2 fields (ID and Name).
In the sheet view, when editing the master dimension, I don't see the 2 original fields.
Why is that and what should I do to see the original fields?