title: SSAS - Data Cube Hierarchy not visible in Excel
body: <p>Initial Request: Create hierarchies over customer names and product descriptions.</p>
  
  <p>Problem:  I created several similar hierarchies and the product description hierarchy is not visible in Excel</p>
  
  <p>Supporting details 
  The computed columns for each hierarchy look like this:</p>
  
  <p>Column Name: Product Description Prefix1
  Expression:</p>
  
  <pre><code>CASE 
  WHEN [ProductDescription] = 'N/A' THEN 'N/A'
  ELSE LEFT([ProductDescription], 1) 
  END 
  </code></pre>
  
  <p>Column Name: Product Description Prefix5
  Expression:</p>
  
  <pre><code>CASE 
  WHEN [ProductDescription] = 'N/A' THEN 'N/A'
  ELSE LEFT([ProductDescription], 5) 
  END
  </code></pre>
  
  <p>Column Name: Product Description Prefix10
  Expression:</p>
  
  <pre><code>CASE 
  WHEN [ProductDescription] = 'N/A' THEN 'N/A'
  ELSE LEFT([ProductDescription], 10) 
  END
  </code></pre>
  
  <p>In my product dimension, I created a Product Description Hierarchy that is leveled </p>
  
  <ul>
  <li>Product Description Prefix1</li>
  <li>Product Description Prefix5</li>
  <li>Product Description Prefix10</li>
  <li>Product Description</li>
  </ul>
  
  <p>With 1 being an attribute relationship to 5, 5 to 10, 10 to Product Description, and Product Description to the Key: Product.</p>
  
  <p>Each one of these attributes have their KeyColumn collections are set:
  Product Description Prefix1's KeyColumns: Being its self
  Product Description Prefix5's KeyColumns: 1 and 5
  Product Description Prefix10's KeyColumns: 1,5,10
  Product Description's KeyColumns: 1,5,10, and Product Description</p>
  
  <p>Right now, I'm choosing AttributeHierarchyVisible = False because I don't want the user to to be able to select the individual attribute.</p>
  
  <p>Any help as to what I am missing causing the hierarchy to become visible would be much appreciated</p>