I created my own mondrian schema using Schema Workbench and published to Pentaho CE 4.8. The schema worked well when I created new analysis using Saiku. But when I used drill through on cell, it always returned empty result without any error message. Any clue what may go wrong and how to debug it?

I tried on the SteelwheelsSales schema, the drill through function worked.

By the way, I used Pentaho 4.8 CE on Ubuntu and Saiku plugin 2.7.

Here is the schema:

<Schema name="My Schema">
<Dimension type="TimeDimension" visible="true" highCardinality="false" name="Date">
<Hierarchy name="Months" visible="true" hasAll="true" primaryKey="date_key">
<Table name="dim_date_en_us">
</Table>
<Level name="Year" visible="true" column="year4" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
</Level>
<Level name="Quarter" visible="true" column="quarter_number" ordinalColumn="quarter_number" type="Numeric" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never" captionColumn="quarter_name">
</Level>
<Level name="Month" visible="true" column="month_number" ordinalColumn="month_number" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" captionColumn="month_name">
</Level>
</Hierarchy>
<Hierarchy name="Weeks" visible="true" hasAll="true" primaryKey="date_key">
<Table name="dim_date_en_us">
</Table>
<Level name="Year" visible="true" column="year4" type="String" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
</Level>
<Level name="Week" visible="true" column="week_in_year" type="Numeric" uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="Channel">
<Hierarchy name="Channel" visible="true" hasAll="true" primaryKey="channel_id">
<Table name="dim_channel">
</Table>
<Level name="Parent Channel" visible="true" column="parent_channel_id" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" captionColumn="parent_channel_name">
</Level>
<Level name="Channel" visible="true" column="channel_id" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" captionColumn="name">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="CLC_change">
<Hierarchy visible="true" hasAll="true" primaryKey="CLC_change_key">
<Table name="dim_CLC_change">
</Table>
<Level name="CLC_change" visible="true" column="CLC_change_key" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" captionColumn="name">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="Cancel_reason">
<Hierarchy visible="true" hasAll="true" primaryKey="cancel_reason_key">
<Table name="dim_cancel_reason">
</Table>
<Level name="Cancel_reason" visible="true" column="cancel_reason_key" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" captionColumn="cancel_reason">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="Location">
<Hierarchy visible="true" hasAll="true" primaryKey="account_id">
<Table name="dim_customer">
</Table>
<Level name="Country" visible="true" column="country" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" captionColumn="country">
</Level>
<Level name="State" visible="true" column="state" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" captionColumn="state">
</Level>
<Level name="City" visible="true" column="city" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" captionColumn="city">
</Level>
</Hierarchy>
</Dimension>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="Signup_source">
<Hierarchy visible="true" hasAll="true" primaryKey="signup_source_key">
<Table name="dim_signup_source">
</Table>
<Level name="Signup_source" visible="true" column="signup_source_key" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" captionColumn="signup_source">
</Level>
</Hierarchy>
</Dimension>
<Cube name="My Cube" caption="My Cube" visible="true" cache="true" enabled="true">
<Table name="warehouse">
</Table>
<DimensionUsage source="Date" name="Date" caption="Date" visible="true" foreignKey="date_key" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="Channel" name="Channel" visible="true" foreignKey="channel_id" highCardinality="false">
</DimensionUsage>
<Dimension type="StandardDimension" visible="true" highCardinality="false" name="CLC">
<Hierarchy visible="true" hasAll="true" allMemberName="All">
<Level name="CLC" visible="true" column="CLC" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<DimensionUsage source="Date" name="Start_date" caption="StartDate" visible="true" foreignKey="start_date_key" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="CLC_change" name="CLC_change" visible="true" foreignKey="CLC_change_key" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="Date" name="Cancel_date" caption="CancelDate" visible="true" foreignKey="cancel_date_key" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="Cancel_reason" name="Cancel_reason" visible="true" foreignKey="cancel_reason_key" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="Location" name="Location" visible="true" foreignKey="account_id" highCardinality="false">
</DimensionUsage>
<DimensionUsage source="Signup_source" name="Signup_source" visible="true" foreignKey="signup_source_key" highCardinality="false">
</DimensionUsage>
<Measure name="MOU" column="mou" datatype="Integer" aggregator="sum" visible="true">
</Measure>
<Measure name="amountDueCents" column="amount_due" datatype="Integer" aggregator="sum" visible="false">
</Measure>
<Measure name="mrc_amount" column="mrc_amount" datatype="Integer" aggregator="sum" visible="false">
</Measure>
<Measure name="usage_amount" column="usage_amount" datatype="Integer" aggregator="sum" visible="false">
</Measure>
<Measure name="other_amount" column="other_amount" datatype="Integer" aggregator="sum" visible="false">
</Measure>
<Measure name="CNT" column="cnt" datatype="Integer" aggregator="sum" visible="true">
</Measure>
<Measure name="payment_amount" column="payment_amount" datatype="Integer" aggregator="sum" visible="false">
</Measure>
<CalculatedMember name="billed" formatString="#,###.00" formula="([Measures].[mrc_amount]+[Measures].[usage_amount]+[Measures].[other_amount])/100.0" dimension="Measures" visible="true">
</CalculatedMember>
<CalculatedMember name="AmountDue" formatString="#,###.00" formula="([Measures].[amountDueCents])/100.0" dimension="Measures" visible="true">
</CalculatedMember>
<CalculatedMember name="receipts" formatString="#,###.00" formula="([Measures].[payment_amount])/100.0" dimension="Measures" visible="true">
</CalculatedMember>
<CalculatedMember name="MRC" formatString="#,###.00" formula="([Measures].[mrc_amount])/100.0" dimension="Measures" visible="true">
</CalculatedMember>
</Cube>
</Schema>