This is known issue https://issues.apache.org/jira/browse/KYLIN-2787
Thanks for reporting. Yang On Tue, Aug 8, 2017 at 3:53 PM, shendandan <[email protected]> wrote: > Hello! > I use tableau as kylin's visualization tool. And I want to know can I > create calculated field in tableau to select? > " if [还款逾期天数] >90 then [本息余额_1] ELSE 0 END " this is my calculated > field but there is a error when I used the calculated field. > the error is : > [Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error > message is: Error while executing SQL "SELECT SUM((CASE WHEN > ("BASEINFO_REPAY_HIS_FACT_PARTATION"."CUR_LATEDAYS" > 90) THEN > "BASEINFO_REPAY_HIS_FACT_PARTATION"."REMAIN_CAPITAL_INTEREST" ELSE 0 > END)) AS "sum_Calculation_FCFAIAHBFAGFBCEH_ok" FROM > "TN_QUERY"."BASEINFO_REPAY_HIS_FACT_PARTATION" > "BASEINFO_REPAY_HIS_FACT_PARTATION" > LEFT JOIN "TN_QUERY"."DIM_BP_PRODUCT" "DIM_BP_PRODUCT" ON > ("BASEINFO_REPAY_HIS_FACT_PARTATION"."PRODUCT_CODE" = > "DIM_BP_PRODUCT"."PRODUCT_CODE") LEFT JOIN "TN_QUERY"."DIM_BP_SALES_CHANNEL" > "DIM_BP_SALES_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BUSINESS_TYPE" > = "DIM_BP_SALES_CHANNEL"."CHANNEL_CODE") LEFT JOIN > "TN_QUERY"."DIM_FUND_CHANNEL" "DIM_FUND_CHANNEL" ON > ("BASEINFO_REPAY_HIS_FACT_PARTATION"."ROOT_CODE" = > "DIM_FUND_CHANNEL"."FUND_CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_ORG" > "DIM_ORG" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BRANCH_CODE" = > "DIM_ORG"."BRANCH_CODE") ": Can't find any realization. Please confirm with > providers. SQL digest: fact table > TN_QUERY.BASEINFO_REPAY_HIS_FACT_PARTATION,group > by [],filter on [],with aggregates[FunctionDesc [expression=SUM, > parameter=null, returnType=null]].
