title: Mondrian all cube measures are empty
body: <p>I am using the Saiku plugin on Pentaho to analize a cube. Although all demension and measurement fields are visible, there are no facts being displayed, all cells are empty. (If the "Non Empty" option is selected in the toolbar, Saiku returns "No result", when the option is not selected, a table listing all the members correctly in the columns and rows are displayed - just no cell values). Because the member values in the columns and rows are correct, I know Saiku is reading the cube xml file and MySQL data source correctly. I think there might be some issue with the specified measurements, but I cannot find any error (No errors in console or logs that I can see). Note that I get this issue no matter what dimensions I select when cubing in Saiku. This is the Mondrian schema file i created with schema workbench.</p>
  
  <pre><code>&lt;Schema name="Test Small4"&gt;
  &lt;Cube name="Policy Cube" caption="A small test" visible="true" description="Policy data description" cache="true" enabled="true"&gt;
  &lt;Table name="fact_policy"&gt;
  &lt;/Table&gt;
  &lt;Dimension type="StandardDimension" visible="true" foreignKey="deductable_id" highCardinality="false" name="Deductable" caption="Caption: deductable"&gt;
    &lt;Hierarchy visible="true" hasAll="false"&gt;
      &lt;Table name="deductable"&gt;
      &lt;/Table&gt;
      &lt;Level name="Deductable Type" visible="true" column="type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
      &lt;Level name="Deductable Limit" visible="true" column="deductable_limit" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
      &lt;Level name="Deductable Cap" visible="true" column="cap" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
    &lt;/Hierarchy&gt;
  &lt;/Dimension&gt;
  &lt;Dimension type="StandardDimension" visible="true" foreignKey="endorsement_id" highCardinality="false" name="Endorsement" caption="Caption: Endorsement"&gt;
    &lt;Hierarchy visible="true" hasAll="true"&gt;
      &lt;Table name="endorsement"&gt;
      &lt;/Table&gt;
      &lt;Level name="Endorsement Type" visible="true" column="type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
      &lt;Level name="Endorsement Number" visible="true" column="number" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
      &lt;Level name="Endorsement Effective Date Regular" visible="true" column="effective_date" type="Date" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"&gt;
      &lt;/Level&gt;
    &lt;/Hierarchy&gt;
  &lt;/Dimension&gt;
  &lt;Measure name="Quantity Unique Rate" column="rate" datatype="Numeric" aggregator="distinct-count" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="Average Rate" column="rate" datatype="Numeric" aggregator="avg" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="Average Premium" column="premium" datatype="Numeric" formatString="#,###" aggregator="avg" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="Num Rates" column="rate" datatype="Integer" aggregator="distinct-count" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="String test" column="rate" datatype="String" aggregator="distinct count" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="Sum test" column="system_id" datatype="Integer" aggregator="sum" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;Measure name="Test" column="system_id" datatype="Integer" formatString="Standard" aggregator="count" visible="true"&gt;
  &lt;/Measure&gt;
  &lt;CalculatedMember name="Premium Rate dif" formula="[Measures].[Average Rate]-[Measures].[Average Premium]" dimension="Measures" visible="true"&gt;
  &lt;/CalculatedMember&gt;
  </code></pre>
  
  <p>
  </p>
  
  <p>Any idea why this might be? How can I go about debugging this issue?</p>