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]].