title: How to set up dynamic hierarchies in OLAP
body: <p>I'm currently setting up a bi-solution, and having difficulties by defining the cube and its hierarchies. </p>
  
  <p>A part of the schema definition looks like this:</p>
  
  <pre><code>&lt;Dimension foreignKey="user" highCardinality="false" name="user"&gt;
    &lt;Hierarchy name="user" hasAll="true" allMemberName="all" primaryKey="ID"&gt;
      &lt;Table name="user" /&gt;
      &lt;Level name="timezone" column="timezone"/&gt;
      &lt;Level name="locale" column="locale"/&gt;
      &lt;Level name="gender" column="gender"/&gt;
      &lt;/Level&gt;
    &lt;/Hierarchy&gt;
  &lt;/Dimension&gt;
  </code></pre>
  
  <p>Now I want to access the gender level directly.</p>
  
  <pre><code>SELECT
  {[user].[gender].Members} ON COLUMNS,
  {[Measures].[Fact Count]} ON ROWS
  FROM [cube]
  </code></pre>
  
  <p>Results in something like <code>[user].[zone3].[de_DE].[male] = 10, [user].[zone1].[en_US].[male] = 30</code> and so on. I want a total for each sex: <code>[user].[male] = 20</code> and <code>[user].[female] = 30</code>. </p>
  
  <p>In summary, I need a flexible ordering of the levels. Is this possible? I know there are parallel hierarchies but i cannot create one for every possible order...</p>
  
  <p>I also tried to put all attributes in properties instead of levels but I could not figure out to get a simple total amount of male/female users.</p>
  
  <p>And it has to be quite simple because the whole thing will be part of a dynamic bi-tool...</p>