First, find all levels that describe location data, then add the appropriate annotations as shown and explained below:
<Level name="CITY" column="CITY" type="String" uniqueMembers="false"> <Annotations> <Annotation name="Data.Role">Geography</Annotation> <Annotation name="Geo.Role">city</Annotation> </Annotations> </Level>
Data.Role: Indicates the type of level. Presently, the only valid data role type is Geography.
Geo.Role: Specifies the geographical classification (city, state, zip, etc.). While there are built-in types used in the Data Source Wizard and PDI modelers, the values are arbitrary. You could specify a "city" type and, as long as the service provides data for this classification, it will work.
Note: In the above example, the city role
retrieves centroid coordinates.