title: SSAS - How to create a geographical dimension?
body: <p>I'm working on a SQL Server Analysis Services multidimensionnal cube.
  I want to create a geaographical dimension to allow user to explore the data regarding to a specific country, region, department, city, store.</p>
  
  <p><code>Country &gt; Region &gt; Department &gt; City &gt; Store &gt; Sale</code></p>
  
  <p>So I created a new dimension by selecting the Sale table including all cascading dependencies.
  Then, I dragged items'name to create a hierachy as the screen capture bellow explains.</p>
  
  <p><img src="https://i.stack.imgur.com/iWBE9.png" alt="enter image description here"></p>
  
  <p>This is the diagram of all relationships between attributes.
  <img src="https://i.stack.imgur.com/QVvff.png" alt="enter image description here"></p>
  
  <p>Finally, after processing I can browse the dimension.
  However, there is something that scaring me, I can't browse stores, there are only country, region, department and city nodes. So how to configure to display stores ?</p>
  
  <p><img src="https://i.stack.imgur.com/Mpr7i.png" alt="enter image description here"></p>
  
  <p>Is there a way to display only branches containing stores because it's not relevant to display 36 000 cities for only 80 stores.</p>
  
  <p>As you can seen, there are three warnings :</p>
  
  <pre><code>Avertissement   10  AttributeRelationship [DimStore].[Sale].[Id_] : Le nom spécifié pour la relation d'attribut diffère du nom de l'attribut associé.       0   0   
  Avertissement   11  AttributeRelationship [DimStore].[Store].[Name_] : Le nom spécifié pour la relation d'attribut diffère du nom de l'attribut associé.        0   0   
  Avertissement   12  Dimension [DimStore] : Éviter les hiérarchies d'attributs visibles pour les attributs utilisés comme niveaux dans les hiérarchies définies par l'utilisateur.       0   0   
  </code></pre>
  
  <p>Any idea to solve that ?</p>