-
-
zhangfeifei 初学数据Lv2
发表于2018-10-12 11:43
悬赏1
已解决
楼主
FACT_DRUG_CONSUM_MONTH_ANTI.PAT_ADMIT_TYPE_CD='mz' and dim(FACT_DRUG_CONSUM_MONTH_ANTI.DRUG_CD,'ANTIBIOTIC_LEVEL_CD') in ['00','01','02','03']这是条件
bi42解析结果
select sum(a.AMOUNT/10000) as B3
from FACT_DRUG_CONSUM_MONTH a
,DIM_ANTIBIOTIC b
,DIM_ANTIBIOTIC c
,DIM_ANTIBIOTIC d
,DIM_ANTIBIOTIC e
where (A.DRUG_CD=B.DRUG_CD(+)) and (A.DRUG_CD=C.DRUG_CD(+)) and (A.DRUG_CD=D.DRUG_CD(+)) and (A.DRUG_CD=E.DRUG_CD(+)) and ((a.BBQ='201809') AND (((a.PAT_ADMIT_TYPE_CD) = 'mz') AND (b.ANTIBIOTIC_LEVEL_CD = '00' or c.ANTIBIOTIC_LEVEL_CD = '01' or d.ANTIBIOTIC_LEVEL_CD = '02' or e.ANTIBIOTIC_LEVEL_CD = '03')))
bi47解析结果
select sum(a.AMOUNT/10000) as B3
from FACT_DRUG_CONSUM_MONTH a
where (a.BBQ='201804') AND (a.PAT_ADMIT_TYPE_CD = 'mz') AND ((null.PHARMACOLOGY_CD IN '00') or (null.PHARMACOLOGY_CD IN '01') or a.DRUG_CD = '02' or (null.PHARMACOLOGY_CD IN '03'))))
想请教一下在固定分析表里求数据表字段的合，过滤掉关联维表中的值，47里公式该怎么写？
bi42解析结果
select sum(a.AMOUNT/10000) as B3
from FACT_DRUG_CONSUM_MONTH a
,DIM_ANTIBIOTIC b
,DIM_ANTIBIOTIC c
,DIM_ANTIBIOTIC d
,DIM_ANTIBIOTIC e
where (A.DRUG_CD=B.DRUG_CD(+)) and (A.DRUG_CD=C.DRUG_CD(+)) and (A.DRUG_CD=D.DRUG_CD(+)) and (A.DRUG_CD=E.DRUG_CD(+)) and ((a.BBQ='201809') AND (((a.PAT_ADMIT_TYPE_CD) = 'mz') AND (b.ANTIBIOTIC_LEVEL_CD = '00' or c.ANTIBIOTIC_LEVEL_CD = '01' or d.ANTIBIOTIC_LEVEL_CD = '02' or e.ANTIBIOTIC_LEVEL_CD = '03')))
bi47解析结果
select sum(a.AMOUNT/10000) as B3
from FACT_DRUG_CONSUM_MONTH a
where (a.BBQ='201804') AND (a.PAT_ADMIT_TYPE_CD = 'mz') AND ((null.PHARMACOLOGY_CD IN '00') or (null.PHARMACOLOGY_CD IN '01') or a.DRUG_CD = '02' or (null.PHARMACOLOGY_CD IN '03'))))
想请教一下在固定分析表里求数据表字段的合，过滤掉关联维表中的值，47里公式该怎么写？
