我找到了解决方案 - 问题出在日期错误的维度上。
详情请见: 在mysql中创建日期范围
新蒙德里安架构:
<Schema name="MondrianSchema"> <Dimension type="TimeDimension" visible="true" highCardinality="false" name="X dimension"> <Hierarchy name="X_hierarchy" visible="true" hasAll="true" primaryKey="date_key"> <Table name="tbl_declaration_date_dim" schema="dbo"> </Table> <Level name="Year" visible="true" table="tbl_declaration_date_dim" column="Year" nameColumn="Year" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" visible="true" table="tbl_declaration_date_dim" column="Month" nameColumn="Month" ordinalColumn="Month" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="Day" visible="true" table="tbl_declaration_date_dim" column="Day" nameColumn="Day" ordinalColumn="Day" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="TimeDimension" visible="true" name="Y dimension"> <Hierarchy name="Y_Hierarchy" visible="true" hasAll="true" primaryKey="date_key"> <Table name="tbl_declaration_date_dim" schema="dbo" alias=""> </Table> <Level name="Year" visible="true" table="tbl_declaration_date_dim" column="Year" nameColumn="Year" type="Numeric" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never"> </Level> <Level name="Month" visible="true" table="tbl_declaration_date_dim" column="Month" nameColumn="Month" ordinalColumn="Month" type="Numeric" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never"> </Level> <Level name="Day" visible="true" table="tbl_declaration_date_dim" column="Day" nameColumn="Day" ordinalColumn="Day" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Cube name="tbl_application_cube" caption="..." visible="true" description="..." cache="true" enabled="true"> <Table name="tbl_appl_olap_fact" schema="dbo"> </Table> <DimensionUsage source="X dimension" name="X axis" visible="true" foreignKey="date_dim" highCardinality="false"> </DimensionUsage> <DimensionUsage source="Y dimension" name="Y axis" visible="true" foreignKey="date_dim"> </DimensionUsage> <Measure name="DeclarationCount" column="declaration_id" aggregator="count" visible="true"> </Measure> </Cube> </Schema>