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'
????????????????????
