Hi, 1.???????????????? SELECT DEPARTMENT.DEPARTMENTNAME AS "????", SUM(ICSTOCKBILL_1W.TOTALMONEY) AS "????", SUM(ICSTOCKBILL_1W.TOTALDECIMAL) AS "????" FROM ICSTOCKBILL_1W INNER JOIN DEPARTMENT ON ICSTOCKBILL_1W.DEPARTMENTID = DEPARTMENT.DEPARTMENTID INNER JOIN ( select * from T_RIGHT_POWERBI_ROLE as R1 where R1.FTABLEID = 'suppmarket2005_cw_test.department' AND R1.FROLEID = 'role62e707b95f1511e89246cb029cf035cd' AND R1.FDSVID = 'view-b528c240-8155-11e7-9647-1b109f7783f6' ) as f2 ON DEPARTMENT.DEPARTMENTNAME = f2.FDIMID GROUP BY DEPARTMENT.DEPARTMENTNAME ORDER BY DEPARTMENT.DEPARTMENTNAME;
???????????????????? 2.????cast ?????????? SELECT DEPARTMENT.DEPARTMENTNAME AS "????", SUM(ICSTOCKBILL_1W.TOTALMONEY) AS "????", SUM(ICSTOCKBILL_1W.TOTALDECIMAL) AS "????" FROM ICSTOCKBILL_1W INNER JOIN DEPARTMENT ON ICSTOCKBILL_1W.DEPARTMENTID = DEPARTMENT.DEPARTMENTID INNER JOIN ( select * from T_RIGHT_POWERBI_ROLE as R1 where R1.FTABLEID = 'suppmarket2005_cw_test.department' AND R1.FROLEID = 'role62e707b95f1511e89246cb029cf035cd' AND R1.FDSVID = 'view-b528c240-8155-11e7-9647-1b109f7783f6' ) as f2 ON CAST(DEPARTMENT.DEPARTMENTNAME AS VARCHAR(300)) = f2.FDIMID GROUP BY DEPARTMENT.DEPARTMENTNAME ORDER BY DEPARTMENT.DEPARTMENTNAME; Best regards ?????????? 2019-04-03 09:29:02,954 ERROR [http-nio-7070-exec-7] controller.BasicController:63 : org.apache.kylin.rest.exception.InternalErrorException: No model found for OLAPContext, CUBE_NOT_READY, CUBE_NOT_CONTAIN_ALL_COLUMN[1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_SUM_ICSTOCKBILL_1W_QUANTITY_, 1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_SUM_ICSTOCKBILL_1W_TOTALMONEY_, 1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_SUM_ICSTOCKBILL_1W_SALEPRICE_, 1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_SUM_ICSTOCKBILL_1W_PRICE_, 1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_SUM_ICSTOCKBILL_1W_TOTALDECIMAL_, 1_738a657b:DEFAULT.ICSTOCKBILL_1W._KY_COUNT__], rel#19685:OLAPTableScan.OLAP.[](table=[DEFAULT, ICSTOCKBILL_1W],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]), JoinDesc [type=INNER, primary_key=[DEPARTMENTID], foreign_key=[DEPARTMENTID]] while executing SQL: "... ????????cast??????????????? ??????????????????:cast ????????????????????sql?????? SELECT * FROM T_RIGHT_POWERBI_ROLE LEFT JOIN ( SELECT DEPARTMENT.DEPARTMENTNAME AS "????", SUM(ICSTOCKBILL_1W.TOTALMONEY) AS "????", SUM(ICSTOCKBILL_1W.TOTALDECIMAL) AS "????" FROM ICSTOCKBILL_1W INNER JOIN DEPARTMENT ON ICSTOCKBILL_1W.DEPARTMENTID = DEPARTMENT.DEPARTMENTID GROUP BY DEPARTMENT.DEPARTMENTNAME ORDER BY DEPARTMENT.DEPARTMENTNAME ) as f2 ON T_RIGHT_POWERBI_ROLE.FDIMID = CAST("????" AS VARCHAR(300)) where T_RIGHT_POWERBI_ROLE.FTABLEID = 'suppmarket2005_cw_test.department' AND T_RIGHT_POWERBI_ROLE.FROLEID = 'role62e707b95f1511e89246cb029cf035cd' AND T_RIGHT_POWERBI_ROLE.FDSVID = 'view-b528c240-8155-11e7-9647-1b109f7783f6' ????????????????????