Skip to content

C
cyyy
Switch branch/tag
Find file
Normal viewHistoryPermalink
新建文本文档 (2).txt.84bd0550-1391-45be-9cd4-b98b983c2393 5.17 KB
Edit
Newer Older
初始化
43f58a36
 
zhangfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 
 with    member [日期].[YMD].[period] as  aggregate({[日期].[YMD].[Y].
&[2021].
&[01]:[日期].[YMD].[Y].
&[2021].
&[01]})   member [日期].[YMD].[periodtq] as  aggregate({[日期].[YMD].[Y].
&[2020].
&[01]:[日期].[YMD].[Y].
&[2020].
&[01]})   member [日期].[YMD].[periodsq] as  aggregate({[日期].[YMD].[Y].
&[2020].
&[12]:[日期].[YMD].[Y].
&[2020].
&[12]})   member [tname] as [医改指标二].[层次].currentmember.name  
member [医改指标二].[层次].[例均费用] as   
  IIF([医改指标二].[层次].[指标].&[IAW_CYRS] is null,0,[医改指标二].[层次].&[IAF_YLSR]/[医改指标二].[层次].[指标].&[IAW_CYRS])
member [医改指标二].[层次].[例均药费] as    
[医改指标二].[层次].&[IAF_YPSR]/[医改指标二].[层次].[指标].&[IAW_CYRS]  
member [医改指标二].[层次].[例均医事服务费] as [医改指标二].[层次].&[IAF_YSF]/[医改指标二].[层次].[指标].&[IAW_CYRS]  
member [医改指标二].[层次].[例均材料费] as   [医改指标二].[层次].&[IAF_CLF]/[医改指标二].[层次].[指标].&[IAW_CYRS]   
member [医改指标二].[层次].[例均检查费] as  [医改指标二].[层次].&[IAF_JCF]/[医改指标二].[层次].[指标].&[IAW_CYRS]   
member [医改指标二].[层次].[例均化验费] as [医改指标二].[层次].&[IAF_HYF]/[医改指标二].[层次].[指标].&[IAW_CYRS]  
member [医改指标二].[层次].[例均治疗费] as [医改指标二].[层次].&[IAF_ZLF]/[医改指标二].[层次].[指标].&[IAW_CYRS]  
member [医改指标二].[层次].[例均手术费] as [医改指标二].[层次].&[IAF_SSF]/[医改指标二].[层次].[指标].&[IAW_CYRS]  
member [医改指标二].[层次].[例均其他费用] as [医改指标二].[层次].[其他费（万元）]/[医改指标二].[层次].[指标].&[IAW_CYRS] 
member [医改指标二].[层次].[例均床位费] as [医改指标二].[层次].[指标].&[IAF_CWF] /[医改指标二].[层次].[指标].&[IAW_CYRS]   
member [医改指标二].[层次].[例均护理费] as [医改指标二].[层次].[指标].&[IAF_HLF]/[医改指标二].[层次].[指标].&[IAW_CYRS]   
member [医改指标二].[层次].[总诊疗人次] as [医改指标二].[层次].&[OAW_PT]+[医改指标二].[层次].&[OAW_FZR]+[医改指标二].[层次].&[OAW_ZR]+[医改指标二].[层次].&[OAW_ZMZJ]+[医改指标二].[层次].&[OAW_JZ]   
member [医改指标二].[层次].[次均费用] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_YLSR]/[医改指标二].[层次].[总诊疗人次])  
member [医改指标二].[层次].[次均药费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_YPSR]/[医改指标二].[层次].[总诊疗人次])    
member [医改指标二].[层次].[次均医事服务费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_YSF]/[医改指标二].[层次].[总诊疗人次])    
member [医改指标二].[层次].[次均材料费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_CLF]/[医改指标二].[层次].[总诊疗人次])        
member [医改指标二].[层次].[次均检查费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_JCF]/[医改指标二].[层次].[总诊疗人次])    
member [医改指标二].[层次].[次均化验费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_HYF]/[医改指标二].[层次].[总诊疗人次])        
member [医改指标二].[层次].[次均治疗费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_ZLF]/[医改指标二].[层次].[总诊疗人次])   
member [医改指标二].[层次].[次均手术费] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].&[OAF_SSF]/[医改指标二].[层次].[总诊疗人次])  
member [医改指标二].[层次].[次均其他费用] as iif([医改指标二].[层次].[总诊疗人次]=0,0,[医改指标二].[层次].[其他费（万元）]/[医改指标二].[层次].[总诊疗人次])    
member [当期值] as ([Measures].[门诊指标值],[日期].[YMD].[period]),FORMAT_STRING = "0.00"  
member [同期值] as ([Measures].[门诊指标值],[日期].[YMD].[periodtq]),FORMAT_STRING = "0.00"  
member [上期值] as ([Measures].[门诊指标值],[日期].[YMD].[periodsq]),FORMAT_STRING = "0.00"  
member [同比变化率] as IIF([同期值]=0,NULL,([当期值]-[同期值])/[同期值]),FORMAT_STRING = "percent" 
member [环比变化率] as IIF([上期值]=0,NULL,([当期值]-[上期值])/[上期值]),FORMAT_STRING = "percent"  
select {[医改指标二].[层次].[次均费用],[医改指标二].[层次].[次均药费],[医改指标二].[层次].[次均医事服务费],[医改指标二].[层次].[次均材料费],[医改指标二].[层次].[次均检查费] ,[医改指标二].[层次].[次均化验费],[医改指标二].[层次].[次均治疗费],[医改指标二].[层次].[次均手术费] }  *{[当期值],[同期值],[上期值],[同比变化率],[环比变化率]} 
on 0,  {[医院].[医院].[全部医院],[医院].[医院].[医院].members} on 1   from [GGFZC_YGJC];