title: Create Hierarchy Parent-child from 2 dimensions in SSAS
body: <p>Is it possible to create an hierarchy from 2 dimensions? Dim_Account and Dim_AccountGroup?
  <a href="https://i.stack.imgur.com/h1mta.png" rel="nofollow noreferrer">The schema</a>
  The hierachies are created in ssas but I have these 'Unknown' values when I create a report in Excel. Do you have an explanation of these unkown values?</p>
  <p><a href="https://i.stack.imgur.com/JGcVF.png" rel="nofollow noreferrer">Report in Excel</a></p>