saiku3.15 查询结果出现重复行且数据错误

Question

我使用的版本是mondrian4,saiku3.15,mysql5.7

如图saiku查询出现了错误的查询结果

而正确的结果应该是这样的

可以看到是有两行isNoLink不同而approve相同的行被错误合并了

这是上述错误查询结果的维度表

这是项目最后生成的数据结构

根据我自查，除了时间维度，其它维度中只有层次的（Schema文件定义level顺序上）第一个级别作为行列查询能出现正确结果。

无论查询中有几个行或者列，只要查询中添加了至少一个层次的（Schema文件定义level顺序上）非第一级别，就一定会出现错误重复行和数据。
反之如果行列都是层次的（Schema文件定义level顺序上）第一级别，那么能得到正确的数据

网上关于mondrian4的资料真的很少，所以没办法只能自己摸索写mondrian4 schema文件,如下

<?xml version="1.0" encoding="UTF-8"?>
<Schema name="zctag_schema" metamodelVersion="4.0" xsi:noNamespaceSchemaLocation="mondrian4.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <PhysicalSchema>
        <Table name="orders" keyColumn="proWoCode" />
        <Table name="appOrg" keyColumn="proWoCode" />
        <Table name="time" keyColumn="proWoCode" />
        <Table name="type" keyColumn="proWoCode" />
        <Table name="condition" keyColumn="proWoCode" />
        <Link source="appOrg" foreignKeyColumn="proWoCode" target="orders" />
        <Link source="time" foreignKeyColumn="proWoCode" target="orders" />
        <Link source="type" foreignKeyColumn="proWoCode" target="orders" />
        <Link source="condition" foreignKeyColumn="proWoCode" target="orders" />
    </PhysicalSchema>

    <Cube name="zctag_cube">

        <Dimensions>

            <Dimension name="stateTime_Dimension" caption="&#23436;&#25104;&#26102;&#38388;" table="time" key="proWoCode" type="TIME">
                <Attributes>
                    <Attribute name="proWoCode" table="time" keyColumn="proWoCode" hasHierarchy="false" />
                    <Attribute name="year" table="time" keyColumn="year" hasHierarchy="false"  />
                    <Attribute name="month" table="time" keyColumn="month" hasHierarchy="false"  />
                    <Attribute name="day" table="time" keyColumn="day" hasHierarchy="false" />
                </Attributes>
                <Hierarchies>
                    <Hierarchy name="stateTime_Hierarchy"
                        caption="&#26102;&#38388;&#36724;"
                        allMemberName="all stateTime_Hierarchy" allMemberCaption="&#25152;&#26377;&#26102;&#38388;" hasAll="true">
                        <Level attribute="year"
                            caption="&#24180;&#20221;" />
                        <Level attribute="month"
                            caption="&#26376;&#20221;" />
                        <Level attribute="day"
                            caption="&#26085;&#26399;" />
                    </Hierarchy>
                </Hierarchies>
            </Dimension>

            <Dimension name="appOrg_Dimension" caption="&#25215;&#21150;&#21333;&#20301;" table="appOrg" key="proWoCode">
                <Attributes>
                    <Attribute name="proWoCode" table="appOrg" keyColumn="proWoCode" hasHierarchy="false" />
                    <Attribute name="appOrgName" table="appOrg" keyColumn="appOrgName" hasHierarchy="false" />
                </Attributes>
                <Hierarchies>
                    <Hierarchy name="appOrg_Hierarachy"
                        caption="&#21333;&#20301;&#20449;&#24687;" allMemberName="all appOrg_Hierarchy" 
                        allMemberCaption="&#25152;&#26377;&#21333;&#20301;&#20449;&#24687;" hasAll="true">
                        <Level attribute="appOrgName" caption="&#21333;&#20301;&#21517;&#23383;" />
                    </Hierarchy>
                </Hierarchies>
            </Dimension>

            <Dimension name="type_Dimension" caption="&#20998;&#31867;" table="type" key="proWoCode">
                <Attributes>
                    <Attribute name="proWoCode" table="type" keyColumn="proWoCode" hasHierarchy="false" />
                    <Attribute name="type" table="type" keyColumn="type" hasHierarchy="false" />
                    <Attribute name="classify" table="type" keyColumn="classify" hasHierarchy="false" />
                    <Attribute name="firstActName" table="type" keyColumn="firstActName" hasHierarchy="false" />
                    <Attribute name="secondActName" table="type" keyColumn="secondActName" hasHierarchy="false" />
                    <Attribute name="thirdActName" table="type" keyColumn="thirdActName" hasHierarchy="false" />
                </Attributes>
                <Hierarchies>
                    <Hierarchy name="type_Hierarchy" caption="&#35814;&#32454;&#20998;&#31867;"
                        allMemberName="all type_Hierarchy" allMemberCaption="&#25152;&#26377;&#20998;&#31867;" hasAll="true">
                        <Level attribute="type" caption="&#31867;&#22411;" />
                        <Level attribute="classify" caption="&#31867;&#21035;" />
                        <Level attribute="firstActName" caption="&#38382;&#39064;&#19968;&#32423;&#20998;&#31867;" />
                        <Level attribute="secondActName" caption="&#38382;&#39064;&#20108;&#32423;&#20998;&#31867;" />
                        <Level attribute="thirdActName" caption="&#38382;&#39064;&#19977;&#32423;&#20998;&#31867;" />
                    </Hierarchy>
                </Hierarchies>          
            </Dimension>

            <Dimension name="condition_Dimension" caption="&#23436;&#25104;&#24773;&#20917;" table="condition" key="proWoCode">
                <Attributes>
                    <Attribute name="proWoCode" table="condition" keyColumn="proWoCode" hasHierarchy="false" />
                    <Attribute name="isNoLink" table="condition" keyColumn="isNoLink" hasHierarchy="false" />
                    <Attribute name="approve" table="condition" keyColumn="approve" hasHierarchy="false" />
                </Attributes>
                <Hierarchies>
                    <Hierarchy name="condition_Hierarchy" caption="&#35814;&#32454;&#29366;&#20917;"
                        allMemberName="all condition_Hierarchy" allMemberCaption="&#25152;&#26377;&#24773;&#20917;" hasAll="true">
                        <Level attribute="isNoLink" caption="&#22238;&#35775;&#24773;&#20917;" />
                        <Level attribute="approve" caption="&#28385;&#24847;&#24773;&#20917;" />
                    </Hierarchy>
                </Hierarchies>
            </Dimension>

        </Dimensions>

        <MeasureGroups>
            <MeasureGroup name="orders" table="orders">
                <Measures>
                    <Measure name="count" caption="&#24635;&#25968;&#37327;" column="proWoCode" aggregator="distinct-count" datatype="Integer"/>
                    <Measure name="avgDotime" caption="&#24179;&#22343;&#21150;&#29702;&#26102;&#38271;" column="dotime" aggregator="avg" datatype="String" />
                </Measures>                 
                <DimensionLinks>
                    <ForeignKeyLink dimension="stateTime_Dimension" foreignKeyColumn="proWoCode" />
                    <ForeignKeyLink dimension="appOrg_Dimension" foreignKeyColumn="proWoCode" />
                    <ForeignKeyLink dimension="type_Dimension" foreignKeyColumn="proWoCode" />
                    <ForeignKeyLink dimension="condition_Dimension" foreignKeyColumn="proWoCode" />
                </DimensionLinks>
            </MeasureGroup>
        </MeasureGroups>

    </Cube>
</Schema>

这个问题我百度谷歌找了好久也没有找到类似的问题，再加上saiku，mondrian4资料又少，真是无能为力了，请大佬们不吝赐教