How to integrate Kylin and Mondrian with dialect in Pentaho 7.1.0.0

[dujijun007]

Due to Kylin can only accept sql with explicit join, I have tried to apply the patch of kylin dialect for mondrian-4.4-lagunitas https://github.com/mustangore/kylin-mondrian-interaction ,then I put the jar in {Pentaho_Home}/tomcat/webapps/pentaho/WEB-INF/lib, but it occurs error: java.lang.NoSuchFieldException: cubes.

Then I find the latest mondrian(8.1) and apply the patch of mondrian-4.4-lagunitas, but it doesn't work at all.
My mdx is :
WITH
SET [~ROWS] AS
{[DimOrganization.default].[EducationBureau].Members}
SELECT
NON EMPTY {[Measures].[RunTime]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [RunInfoCube]

And the sql translated is :
sql=[select "DIMORGANIZATION"."EDUBUREAUNAME" as "c0", sum("FACTINFO"."RUNTIME") as "m0" from "DEFAULT"."DIMORGANIZATION" as "DIMORGANIZATION", "DEFAULT"."FACTINFO" as "FACTINFO" where "FACTINFO"."ORGANIZATIONKEY" = "DIMORGANIZATION"."ORGANIZATIONKEY" and "DIMORGANIZATION"."EDUBUREAUNAME" = 'Tedsiud School' group by "DIMORGANIZATION"."EDUBUREAUNAME"]

Version:
Pentaho 7.x
Kylin 2.x

[zhengguilin]

i have same problem，wait for help

[dobeslao]

I have tried the same steps without luck. I have also updated "mondrian.spi.Dialect" with the value "mondrian.spi.impl.KylinDialect".

But there is also another unresolved problem with master branch. Code doesn't honor "allowsJoinOn" feature. Please refer to: https://jira.pentaho.com/browse/MONDRIAN-955. I have modified it, but it keeps generating SQL in the same way.

Also i think case #480 is unresolved and they're closing.

Version tested:
Pentaho 8.2.x
Kylin 2.6.x