18个回答
2018-08-16 21:11:42 开始计算报表：FDQHZB（内存情况：FREE=146.2M TOTAL=247.7M MAX=494.9M）
2018-08-16 21:11:42 引用的主题表：Z1 流感样病例报告一览表
2018-08-16 21:11:42 查询的数据级次范围：没有做限制。
2018-08-16 21:11:42 计算表格GRID1
2018-08-16 21:11:42 生成SQL耗时12毫秒
2018-08-16 21:11:42 执行SQL:
select * from ( select max(a.ADMIDICODE) as B2,sum(a.FLUCARDSUM) as C2,sum( if((a.NLDW = '岁') AND (a.SZNL >= 0) AND (a.SZNL < 5),a.FLUCARDSUM,0) OR if((a.NLDW = '天') AND (a.SZNL >= 0),a.FLUCARDSUM,0)) as D2,sum( if((a.NLDW = '岁') AND (a.SZNL >= 5) AND (a.SZNL < 15),a.FLUCARDSUM,0)) as E2,sum( if((a.NLDW = '岁') AND (a.SZNL >= 15) AND (a.SZNL < 25),a.FLUCARDSUM,0)) as F2,sum( if((a.NLDW = '岁') AND (a.SZNL >= 25) AND (a.SZNL < 60),a.FLUCARDSUM,0)) as G2,sum( if((a.NLDW = '岁') AND (a.SZNL >= 60),a.FLUCARDSUM,0)) as H2,b.WEEK as A2,max(c.AdmiDiName) as mc_B20
from zb_flucard a
left join wb_zb b
on (a.BBQ=b.BBQ)
left join wb_admidivi c
on (a.ADMIDICODE=c.AdmiDiCode)
where (((a.BBQ >= '2018----$201801') AND (a.BBQ <= '2018----$201852')) AND ((a.ADMIDICODE like '1509%') AND ((b.WEEK = '201801' and b.year_ = '2018----')) AND ((b.WEEK = '201852' and b.year_ = '2018----'))))
group by b.WEEK ) as temp_ limit 1000
2018-08-16 21:11:42 SQL执行完毕，查询出0条数据，耗时：15毫秒（开始时间：2018-08-16 21:11:42.128；结束时间：2018-08-16 21:11:42.143）；其中生成SQL耗时12毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：1毫秒；执行查询sql耗时：1毫秒；
2018-08-16 21:11:42 执行查询耗时18毫秒。（内存情况：FREE=145.2M TOTAL=247.7M MAX=494.9M）
2018-08-16 21:11:42 构造结果表耗时2毫秒。
2018-08-16 21:11:42 计算“FDQHZB”耗时21毫秒。（内存情况：FREE=145M TOTAL=247.7M MAX=494.9M）
rabbit 发表于 2018-8-16 21:20
2018-08-16 21:11:42 开始计算报表：FDQHZB（内存情况：FREE=146.2M TOTAL=247.7M MAX=494.9M）
2018-0 ...
<reportpage id=TIN0YAUD9UYTQUPIKIRYWEU5KKIIYD7U alias= name=FDQHZB caption="Z4 分地区流感样病例报告汇总表" type=pagetpl>
<option>
maxcount=105
bgimg_position=
childindexs=WidgetPageLayout5,PAGEFLOAT
this-reportid=EBI$12$LBUL7NC4SYYVMUEBDUOMN5Z9NABU8970$1$TXUPCKBK0UDIWZMXIL1MUPJNM6XLYNKM.rpttpl
taskid=LBUL7NC4SYYVMUEBDUOMN5Z9NABU8970
width=100%
bgimg_repeat=no-repeat
borderset=none
isextend=false
bgcolor=
autosize=none
ismini=false
grp=EBI$13$LBUL7NC4SYYVMUEBDUOMN5Z9NABU8970$/
height=100%
vertalign=relate
foldline=true
left=0px
borderradius=5
maxgridcount=2
horzalign=relate
disabled=false
top=0px
zindex=0
</option>
<body>
<WidgetPageLayout id=WidgetPageLayout5 name=WidgetPageLayout>
<option>
bgimg_position=
width=100%
borderset=none
bgimg_repeat=no-repeat
isextend=false
autosize=none
ismini=false
height=100%
vertalign=top
left=0
borderradius=5
horzalign=left
enableSelect=false
disabled=false
top=0
zindex=0
</option>
<body>
<WidgetPageArea id=bodyarea name=BODYAREA>
<option>
bgimg_position=
rptthemecaption=
childindexs=WidgetText98,WidgetTplGrid75
width=100%
borderset=rect
bgimg_repeat=no-repeat
isextend=false
autosize=none
bgcolor=
bordertop="cl=#CCCCCC;stl=0;w=1"
ismini=false
height=100%
vertalign=top
left=0
borderradius=5
horzalign=left
disabled=false
zindex=0
top=0
</option>
<body>
<WidgetText id=WidgetText98 name=HHH2>
<option>
bgimg_position=
align=left
width=304
bgimg_repeat=no-repeat
borderset=rect
borderright="cl=#CCCCCC;stl=5;w=1"
isextend=false
autosize=content
bordertop="cl=#CCCCCC;stl=5;w=1"
ismini=false
height=32
vertalign=relate
borderbottom="cl=#CCCCCC;stl=5;w=1"
left=192
borderleft="cl=#CCCCCC;stl=5;w=1"
borderradius=5
horzalign=relate
valign=top
disabled=false
top=23
zindex=0
</option>
<text>
[{"t":"Z4 分地区流感样病例报告汇总表","stl":{"cl":"#000000","sz":20,"fn":"微软雅黑
</text>
</WidgetText>
<WidgetTplGrid id=WidgetTplGrid75 name=GRID1>
<option>
bgimg_position=
width=583
borderset=none
bgimg_repeat=no-repeat
isextend=false
autosize=none
ismini=false
height=79
vertalign=relate
left=56
borderradius=5
horzalign=relate
disabled=false
top=63
zindex=0
</option>
<grid rowcount=3 colcount=8>
<style>
fn=微软雅黑;sz=12;cl=#000000;stl=;lo=47;bkcl=transparent
</style>
<border>
cl=#CCCCCC;stl=0;w=1
cl=#000000;stl=0;w=1
</border>
<rows>
24
24
24
</rows>
<cols>
72
72
72
72
72
72
72
72
</cols>
<cells>
<cl r=0 c=0>
text=报表期
indent=2.1.2.1
</cl>
<cl r=0 c=1>
text=行政区划
indent=2.1.2.1
l=50
</cl>
<cl r=0 c=2>
text=流感样病例报告数
indent=2.1.2.1
</cl>
<cl r=0 c=3>
text=其中：分年龄组0~
indent=2.1.2.1
l=50
</cl>
<cl r=0 c=4>
text=5~
indent=2.1.2.1
l=50
</cl>
<cl r=0 c=5>
text="[{""t"":""1"",""stl"":{""cl"":""#000000"",""sz"":12,""fn"":""微软雅黑""}},{""t"":""5~"",""stl"":{""cl"":""#000000"",""sz"":12,""fn"":""微软雅黑""}}]"
indent=2.1.2.1
l=50
</cl>
<cl r=0 c=6>
text=25~
indent=2.1.2.1
</cl>
<cl r=0 c=7>
text=60~
indent=2.1.2.1
</cl>
<cl r=1 c=0 t=C l=0>
exp=Z1.BBQ
indent=2.1.2.1
bbqoption="exp:bbq()>=@bbq1 and bbq()<=@bbq2"
selecttype=0
</cl>
<cl r=1 c=1 t=C l=0>
exp=Z1.AdmiDiCode
indent=2.1.2.1
bbqoption=inherited
iszb=true
</cl>
<cl r=1 c=2 t=I l=0>
exp=Z1.FlucardSum
indent=2.1.2.1
</cl>
<cl r=1 c=3 t=I l=0>
exp="IF(Z1.NLDW=""岁""&Z1.SZNL>=0&Z1.SZNL<5,Z1.FlucardSum,0)|IF(Z1.NLDW=""天""&Z1.SZNL>=0,Z1.FlucardSum,0)"
indent=2.1.2.1
</cl>
<cl r=1 c=4 t=I l=0>
exp="IF(Z1.NLDW=""岁""&Z1.SZNL>=5&Z1.SZNL<15,Z1.FlucardSum,0)"
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=1 c=5 t=I l=0>
exp="IF(Z1.NLDW=""岁""&Z1.SZNL>=15&Z1.SZNL<25,Z1.FlucardSum,0)"
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=1 c=6 t=I l=0>
exp="IF(Z1.NLDW=""岁""&Z1.SZNL>=25&Z1.SZNL<60,Z1.FlucardSum,0)"
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=1 c=7 t=I l=0>
exp="IF(Z1.NLDW=""岁""&Z1.SZNL>=60,Z1.FlucardSum,0)"
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=0>
text=合计
indent=2.1.2.1
</cl>
<cl r=2 c=1 t=N l=50.2>
indent=2.1.2.1
l=50
</cl>
<cl r=2 c=2 t=I l=0>
exp=sum(GRID1.C2$)
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=3 t=I l=0>
exp=sum(GRID1.D2$)
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=4 t=I l=0>
exp=sum(GRID1.E2$)
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=5 t=I l=0>
exp=sum(GRID1.F2$)
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=6 t=I l=0>
exp=sum(GRID1.G2$)
indent=2.1.2.1
nulltozero=false
</cl>
<cl r=2 c=7 t=I l=0>
exp=sum(GRID1.H2$)
indent=2.1.2.1
nulltozero=false
</cl>
</cells>
</grid>
<floatfxqs>
<floatfxq rect=0.0.8.3>
<floatcell>
<option>
floatrange=0.1.8.2
cell=A2
float=vert
sumlevel=1
splitfloatrect=false
makedimfull=false
filternotindimdata=false
</option>
</floatcell>
</floatfxq>
</floatfxqs>
<defthemeset>
{"gridborder":{"style":"solid","color":"#CCCCCC","width":1},"cellborder":{"style":"solid","color":"#CCCCCC","width":1},"defstl":{"wrap":false,"halign":2,"colspan":1,"indent":"2.1.2.1","bkcl":"transparent","rowspan":1,"type":"N","ishorz":true,"dec":2,"cl":"#000000","valign":2,"fn":"微软雅黑","sz":12}}
</defthemeset>
</WidgetTplGrid>
</body>
</WidgetPageArea>
<WidgetArea id=toparea name=TOPAREA>
<option>
bgimg_position=
childindexs=WidgetParamComboBoxTree66,WidgetParamComboBoxTree48,WidgetParamComboBoxTree34
width=100%
borderset=rect
bgimg_repeat=no-repeat
horzgap=10
isextend=false
autosize=content
bgcolor=
ismini=false
Cross_border=10
height=100%
vertalign=top
borderbottom="cl=#CCCCCC;stl=0;w=1"
left=0
borderradius=5
horzindent=0
horzalign=left
Vertical_border=5
disabled=false
top=0
conditionArr=WidgetParamComboBoxTree66,WidgetParamComboBoxTree48,WidgetParamComboBoxTree34
zindex=0
</option>
<body>
<WidgetParamComboBoxTree id=WidgetParamComboBoxTree66 name=HHH9>
<option>
recordvalue=true
ismult=true
bgimg_repeat=no-repeat
autosize=none
paramname=@xzqh
height=22
vertalign=relate
left=0
top=5
paramtype=dim
autocalc=false
text=行政区划
bgimg_position=
defvalue=150900
width=200
paramindex=1
pid=toparea
borderset=none
isextend=false
ismini=false
autofilter=true
borderradius=5
textvisible=true
horzalign=relate
disabled=false
zindex=0
</option>
<dim>
autoexpand=false
itemsort=
displaystyle=codetext
itemclickfilter=
includeroot=false
itemfilter=
dimname=W2行政区划
itemroots=
</dim>
</WidgetParamComboBoxTree>
<WidgetParamComboBoxTree id=WidgetParamComboBoxTree48 name=HHH82>
<option>
ismult=false
recordvalue=true
bgimg_repeat=no-repeat
autosize=none
paramname=@bbq1
height=22
vertalign=relate
left=210
paramtype=dim
top=5
autocalc=true
text=起始周
bgimg_position=
width=200
paramindex=2
borderset=none
pid=toparea
isextend=false
ismini=false
autofilter=true
textvisible=true
borderradius=5
horzalign=relate
disabled=false
zindex=0
</option>
<dim>
autoexpand=false
itemsort=
displaystyle=text
itemclickfilter=
includeroot=false
itemfilter=
dimname=W6周报
itemroots=
</dim>
</WidgetParamComboBoxTree>
<WidgetParamComboBoxTree id=WidgetParamComboBoxTree34 name=HHH83>
<option>
recordvalue=true
ismult=false
bgimg_repeat=no-repeat
autosize=none
paramname=@bbq2
height=22
vertalign=relate
left=420
autocalc=true
top=5
paramtype=dim
text=结束周
bgimg_position=
defvalue=201852
width=200
paramindex=3
pid=toparea
borderset=none
isextend=false
ismini=false
autofilter=true
borderradius=5
textvisible=true
horzalign=relate
disabled=false
zindex=0
</option>
<dim>
autoexpand=false
itemsort=
displaystyle=text
itemclickfilter=
includeroot=false
itemfilter=
dimname=W6周报
itemroots=
</dim>
</WidgetParamComboBoxTree>
</body>
</WidgetArea>
</body>
<layout>
<rows count=2>
30,594
</rows>
<cols count=1>
886
</cols>
<cells>
<cell r=1 c=1 rowspan=1 colspan=1 linkid=toparea />
<cell r=2 c=1 rowspan=1 colspan=1 linkid=bodyarea />
</cells>
</layout>
</WidgetPageLayout>
</body>
<rptthemename>
</rptthemename>
<print>
fix_fixrowcount=0
margin_bottom=15
direction=2
headerFontSizeRate=1.0
fix_floatcolcount=0
fix_fixcolcount=0
subfield_multiColumnDistance=0.0
noPrintCol=
printmode=1
noPrintRow=
margin_top=15
fillrowcol=0
subfield_rowwrapdatacount=0
printZero=0
pageHeader=
papertype=A4
alwaysHead=63
fix_floatrowcount=0
subfield_rowwrapdirection=0
subfield_fixrowcolcount=0
single_planarrowcount=0
pageTail=
align=0
printrate=1.0
subfield_rowwrapmaxcolcount=0
cellFontSizeRate=1.0
zoomCellFontSizeByViewRate=0
planar_paginationtype=1
zoomHeaderFontSizeByViewRate=0
margin_left=15
margin_right=15
paginationtype=1
layoutAutoSize=0
valign=0
planar_rowcountperpage=0
</print>
<analyseoption>
bbqoption_caption=全部数据期
</analyseoption>
</reportpage>
rabbit 发表于 2018-8-16 21:20
2018-08-16 21:11:42 开始计算报表：FDQHZB（内存情况：FREE=146.2M TOTAL=247.7M MAX=494.9M）
2018-0 ...
图示
http://localhost:8080/bi42/esmain/login.do#navigator:/esmain/index.do?rshid=welcome
本帖最后由 rabbit 于 2018-8-17 19:34 编辑
rabbit 发表于 2018-8-17 19:11
http://localhost:8080/bi42/esmain/login.do#navigator:/esmain/index.do?rshid=welcome
按照提示做了维表，统一了数据格式，建立了年周维度查询，问题没解决，找不到原因。 报表参数筛选列表不对，显示的是数据表的数据期，不是维表数据期；筛选结果不显示。数据期编辑框打不开，不明原因。设置如下：
1、维表W6周报字段：BBQ：20180101代表2018年第一周第一天……，WEEk：201801代表2018年第一周，DATE：2018-01-01代表2018年1月1日。
2、主题表Z1“报表期字段BBQ”数据格式是2018-01-01，与维表W6周报DATE格式相同；通过维表w6周报与年周建立关联，显示为201801（代表2018年第一周）。
3、主题集属性报表类型为“自定义”，数据期字段是主题表Z1“报表期BBQ”。
4、报表模板BBQ字段设浮动维，数据期条件原来是bbq()>=@bbq1 and bbq()<=@bbq2，目前不能编辑；
5、报表参数@bbq1起始周和@bbq2结束周设为维下拉，维表是w6周报，主题表是Z1。
怀疑： 报表参数@bbq1和@bbq2取数不对，取数结果显示为“201801&20180101”，没与主题表建立起年周维度关联。
Roue 发表于 2018-8-16 15:57
用普通的维表设计即可，要与主题表的日期格式对应，这样才能识别判断是哪周
你具体是怎样做的呢？如果显示 ...
图片上传不了，2653275720，可以加QQ远程看下吗
