title: Dimension that is a subset of another dimension
body: <p>I am trying to create a new dimension in my cube, that is a subset of another dimension. I am working with SQL Server Analyisis Services.</p>
  
  <p>I have a measure that represents the number of employees in my organization, both in brach offices and in the central office, and I have a Location dimension that contains all offices.</p>
  
  <p>I want to create a new dimension that contains only branch offices, so that when I apply it to the measure it show me only the numbers in the branch offices and the total aggregates only the employees in them.</p>
  
  <p>I could create another dimension table with only the branch offices in it, but then I would have employees asigned to an Unknown member (the central office)</p>
  
  <p>I also want to keep the original dimension, where I can see all offices and get the total of employees in the organization.</p>
  
  <p>I understand I could get that result using with my current Location dimension applying a filter to my query, but I was  wondering if it was possible to create a "pre-filtered" dimension.</p>