There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
The following query against the adventure works 2014 database reveals, that the german city "München" seems to be located in 4 different states (Hessen, Nordrhein-Westfalen, Saarland and the city-state Hamburg), none of them is the correct one.
München is located in Bayern.
from person.Address a
left join person.StateProvince sp
group by city,a.StateProvinceID,name
i found this very confusing when Walking through the Analysis Services tutorial. I thought I made misstakes in cofiguring the cube.