tableau is used to view cube query result, at first ,i defined inner join at
data modeling, and every thing is ok, tableau showed the results; but when i
changed to inner join to left join, the cube builded without errors, but
tableau can not show the query result , and the exception as follow:
[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is:
error while executing SQL "SELECT "D_NW_NE_ECELLC"."ECELL_PROVINCE_NAME_ZH" AS
"none_ECELL_PROVINCE_NAME_ZH_nk", SUM("LTE_HTTP_S"."DLDATA") AS
"sum_DLDATA_ok" FROM "DEFAULT"."LTE_HTTP_S" "LTE_HTTP_S" INNER JOIN
"DEFAULT"."D_MINUTE_5" "D_MINUTE_F" ON ("LTE_HTTP_S"."SLICETIME" =
"D_MINUTE_F"."MINUTE_5_ID") INNER JOIN "DEFAULT"."D_NW_NE_ECELL2"
"D_NW_NE_ECELLC" ON ("LTE_HTTP_S"."ECELLOID" = "D_NW_NE_ECELLC"."ECELL_OID")
INNER JOIN "DEFAULT"."D_NW_NE_ENODE_IPADDR2" "D_NW_NE_ENODE_IPADDRC" ON
("LTE_HTTP_S"."ENODEBIPOID" = "D_NW_NE_ENODE_IPADDRC"."ENODEB_IPADDR_OID")
INNER JOIN "DEFAULT"."D_NW_NE_SGW_IPADDR2" "D_NW_NE_SGW_IPADDRC" ON
("LTE_HTTP_S"."SGWIPADDROID" = "D_NW_NE_SGW_IPADDRC"."SGW_IPADDR_OID") INNER
JOIN "DEFAULT"."D_SERVICE_RY_CATEGORY" "D_SERVICE_RY_CATEGORY" ON
("LTE_HTTP_S"."SERVICERYCATEGORYOID" =
"D_SERVICE_RY_CATEGORY"."SERVICE_RY_CATEGORY_OID") GROUP BY
"D_NW_NE_ECELLC"."ECELL_PROVINCE_NAME_ZH"": Can't find any realization. Please
confirm with providers. SQL digest: fact table DEFAULT.LTE_HTTP_S,group by
[DEFAULT.D_NW_NE_ECELL2.ECELL_PROVINCE_NAME_ZH],filter on [],with
aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column,
value=DLDATA], returnType=null], FunctionDesc [expression=COUNT,
parameter=ParameterDesc [type=column, value=DLDATA], returnType=null]].
梁猛
中国移动广东公司 网管维护中心 网管支撑室
电话：13802880779
邮箱: [email protected] ，[email protected]
地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼
邮编：510623
