To use the suggest or auto-suggest features for hierarchy mapping in the application, the hierarchies on the cube within SQL Server Analysis Services need to be configured correctly.
This means that for each Dimension Attribute in the cube that represents some type of geographical location the Type property should be set to the corresponding geographical type. This can be done in the properties window within the SQL Server Business Intelligence Development Studio as illustrated hereunder:
DataWarehouse Explorer recognizes the following types:
When a dimension attribute is used as a level:
Country |
|
StateOrProvince |
|
City |
|
PostalCode |
When the dimension attribute is used in an attribute relationship:
GeoCentroidX |
Will be used as latitude |
GeoCentroidY |
Will be used as longitude |
AddressCountry |
|
AddressStateOrProvince |
|
AddressZip |
|
AddressCity |
|
AddressStreet |
|
Address |
|
Auto-suggest
The auto-suggest feature (i.e. that the mapping is automatically configured for a hierarchy) is only available when each level within the hierarchy can be configured automatically by using attributes with the GeoCentroidX and GeoCentroidY types.