title: Flexible hierarchies in Saiku Analytics
body: <p>I have just started working on Mondrian and I am having a hard time understanding how to set hierarchies work.</p>
  
  <p>Suppose that I have a Hospital dimension and I want to sum the amount of hospitals that are public or private in certain state. I have also my fact hospital with the appropriate measure hospital_amount.</p>
  
  <p>The hierarchy I have built in the Schema Workbench is show below:</p>
  
  <p>1- State <br>
  2- Flag (Private or Public) <br>
  3- City <br>
  4- Hospital <br></p>
  
  <p>Doing in this way I can analyse things in Saiku Analytics plugin without major concerns, provided that I maintain the presentation order of attributes (State, Flag, City,...). But, things turn a little complicated if I want change the order that fields will be presented in the report, in other words, what if I want to build another report in Saiku without using the flag attribute.</p>
  
  <p>Even if I hide the flag, Saiku will continue using it to categorize the rest of the attributes from the hierarchy (City and Hospital).</p>
  
  <p>Some people said that I need to create another hierarchy in the Schema Workbench only for the flag, but this won't let me use the flag in the drill menu of Hospital.</p>
  
  <p>Is there any way to build reports in Saiku without being stuck into the hierarchy order, I mean choosing fields from hierarchy in a flexible way?</p>
  
  <p>Thanks in advance!</p>