Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have given below script , but i reload this come to error massage " Execution script failed Reload old data" to qlick view. but in this script working properly the sql data base.
please help
sagara
SELECT
tra_branch,
PRODUCT,
TRUNC(tra_pol_date),
pri_class_code,
POLICY_NO,
MECODE,
SUM(RIFUND_PREMIUM) RIFUND_PREMIUM,SUM(RIFUND_COMM)RIFUND_COMM
FROM
(select tra_currency,CLASS,POLICY_NO, MONTH,YEAR,tra_pol_date, tra_branch,PRODUCT,pri_class_code,MECODE,
sum(RIFUND_PREMIUM) RIFUND_PREMIUM, sum(RIFUND_COMM) RIFUND_COMM
from
(SELECT tra_currency,tra_class_code CLASS,TRA_POLICY_NO POLICY_NO ,
( SELECT n.RPO_DDC_SEQ FROM uw_t_ri_policies@ri n where n.rpo_pol_seq_no=a.tra_policy_seq ) deb_rec,
to_char(tra_pol_date, 'MM') MONTH,
to_char(tra_pol_date, 'YYYY') YEAR,
tra_branch,
tra_pol_date,
pri_class_code,
tra_prod_code PRODUCT,
(select c.rpo_pol_marketing_executive_co from uw_t_ri_policies@ri c where C.rpo_pol_seq_no=a.tra_policy_seq )MECODE,
b.PRI_RI_PREMIUM*TRA_CUR_CON_RATE RIFUND_PREMIUM,
b.pri_ri_comm*TRA_CUR_CON_RATE RIFUND_COMM
FROM ri_t_polcy_trans a, ri_t_polcy_trans_rein b
where a.tra_trans_seq=b.pri_trans_seq and a.tra_step_no=b.pri_step_no(+)
and to_char(tra_pol_date,'YYYY')='2017'
//BETWEEN '2014-01' AND '2014-08'
and b.pri_reinsurer_code in ('RI FUND','RIFUND','MIFUND')
AND tra_branch like 'CO%'
)
group by tra_currency,YEAR, MONTH,CLASS,PRODUCT,POLICY_NO,tra_branch,tra_pol_date,pri_class_code,deb_rec,MECODE)
group by YEAR,POLICY_NO,tra_pol_date,tra_branch,PRODUCT,pri_class_code,MECODE
Please check this
Is that Query running in SQL engine not Qlikview?
Hi,
Try Following things:
if you are saving any qvd using this script then ensure that you have access to create the qvd in specified folder and also check if you are going to replace the qvd then if that qvd is used in other program.
also if this query is running on sql the //BETWEEN '2014-01' AND '2014-08'
comment in sql is -- instead of //
so replace comments accordingly.
HTH
Sushil