wow,i think i know what the problem is, i should dragged the lowest dimensions first, not the highest
发件人： liangmeng 发送时间： 2015-07-13 14:22 收件人： dev 主题： 回复: Re: error while using left join still not working, i change tableau to be left join ,and it returns: [Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: exception while executing query: null 梁猛 中国移动广东公司 网管维护中心 网管支撑室 电话：13802880779 邮箱: [email protected] ，[email protected] 地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 邮编：510623 发件人： Shi, Shaofeng 发送时间： 2015-07-13 13:34 收件人： [email protected] 主题： Re: error while using left join The SQL that generated by Tableau is still "inner joined” ones, which doesn’t match with the cubes, then Kylin reports “Can't find any realization” error; You may need update your tableau report; On 7/13/15, 1:22 PM, "liangmeng" <[email protected]> wrote: > 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
