title: How do I create a User-Defined Hierarchy that includes a Parent-Child Hierarchy?
body: <p><strong>Environment: SSAS 2005, BIDS 2008.</strong></p>
  
  <p><strong>Data Schema</strong>:</p>
  
  <p>DepartmentMaster </p>
  
  <ul>
  <li>DepartmentNumber <em>int</em> (PARENT)</li>
  <li>SubDepartmentNumber <em>int</em> (CHILD)</li>
  </ul>
  
  <p>CategoryMaster:</p>
  
  <ul>
  <li>DepartmentNumber <em>int references DepartmentMaster.DepartmentNumber</em></li>
  <li>CategoryNumber <em>int</em></li>
  </ul>
  
  <p><strong>Functionality I desire:</strong></p>
  
  <ul>
  <li>Hierarchical drill down:<br>
  <ul>
  <li>Department -> Category      </li>
  <li>Department -> Sub-Department -> Category</li>
  </ul></li>
  </ul>
  
  <p><strong>Accomplished through the following:</strong></p>
  
  <ul>
  <li>Category Dimension</li>
  <li>Department Dimension 
  <ul>
  <li>Parent-Child Hierarchy on Sub-Department and Department.</li>
  </ul></li>
  </ul>
  
  <p><strong>Why this is a problem:</strong></p>
  
  <p>I feel that Category really should be in the same Dimension and call it "Product" or "Item." Initially, without Sub-Department, this is how I had it set up: </p>
  
  <ul>
  <li>Item Dimension
  <ul>
  <li>Department -> Category</li>
  </ul></li>
  </ul>
  
  <p>Unfortunately, once a Parent entity was introduced at the department level, I could no longer configure the attribute relationships in a way that built correctly (or at all).</p>
  
  <p><strong>My question:</strong></p>
  
  <p>Is it possible to configure these relationships such that they are all in one dimension giving me the Hierarchies described above?? If it is possible - should I be? Is it not working well because I'm doing it wrong to begin with? </p>