[ABI 5.1] 分析表中的维信息错误展示

按理说关联了维表之后,报表带出来的应该是维表的中文.不是ID.这里是你配置了吗?

以上这个问题怎么解决呀？有知道的高手么？

提供一下报表，看看具体怎么配置的

你做了四个浮动.前三个显示的结果就是前三个浮动,到第四个分区展示正常了.前三个浮动按照维表的层级汇总了.你看看具体的生成的sql.报表配置的问题

2021-10-14 12:43:38.886 开始计算报表：B93097（内存情况：FREE=10.4G TOTAL=16G MAX=16G）
2021-10-14 12:43:38.886 引用的主题表： cwndyjsbb
2021-10-14 12:43:38.886 查询的数据级次范围：没有做限制。
================GRID1================
2021-10-14 12:43:38 在并行计算线程池中，开始计算表格GRID1的第1个分析区（0.0.16.6）！
2021-10-14 12:43:38 正在生成SQL...
2021-10-14 12:43:38 计算表格GRID1
2021-10-14 12:43:38 生成SQL耗时0毫秒
2021-10-14 12:43:38 当前连接池为【erp_mxk】，执行SQL:
select a.M6,a.N6,a.B6,a.C6,a.D6,a.E6,a.F6,a.H6,a.I6,a.J6,a.K6,a.L6,a.B5,a.C5,a.D5,a.E5,a.F5,a.H5,a.I5,a.J5,a.K5,a.L5,a.M5,a.N5,a.M4,a.N4,a.B4,a.C4,a.D4,a.E4,a.F4,a.H4,a.I4,a.J4,a.K4,a.L4,a.B3,a.C3,a.D3,a.E3,a.F3,a.H3,a.I3,a.J3,a.K3,a.L3,a.M3,a.N3,a.M1,a.G6,a.G5,a.G4,a.G3,a.mc_E63,a.mc_E53,a.mc_E43,a.mc_E33,a.mc_G61,b.M6,b.N6,b.G6,b.G5,b.G4,b.G3,b.mc_G61,c.M6,c.N6,c.M1
from (
select a.M6 as M6,a.N6 as N6,b.B6 as B6,b.C6 as C6,b.D6 as D6,b.E6 as E6,b.F6 as F6,b.H6 as H6,b.I6 as I6,b.J6 as J6,b.K6 as K6,b.L6 as L6,c.B5 as B5,c.C5 as C5,c.D5 as D5,c.E5 as E5,c.F5 as F5,c.H5 as H5,c.I5 as I5,c.J5 as J5,c.K5 as K5,c.L5 as L5,d.M5 as M5,d.N5 as N5,e.M4 as M4,e.N4 as N4,f.B4 as B4,f.C4 as C4,f.D4 as D4,f.E4 as E4,f.F4 as F4,f.H4 as H4,f.I4 as I4,f.J4 as J4,f.K4 as K4,f.L4 as L4,g.B3 as B3,g.C3 as C3,g.D3 as D3,g.E3 as E3,g.F3 as F3,g.H3 as H3,g.I3 as I3,g.J3 as J3,g.K3 as K3,g.L3 as L3,h.M3 as M3,h.N3 as N3,a.M1 as M1,a.G6 as G6,a.G5 as G5,a.G4 as G4,a.G3 as G3,b.mc_E63 as mc_E63,c.mc_E53 as mc_E53,f.mc_E43 as mc_E43,g.mc_E33 as mc_E33,a.mc_G61 as mc_G61
from (
select sum(a.data_y) as M6,sum(a.data_j) as N6,a.date_ as M1,a.fictitious_id as G6, LEFT(a.fictitious_id,5) as G5, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3,max(b.NAME) as mc_G61
from CWNDYJSBB a
left join ysxmdyb b
on (a.fictitious_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5),a.fictitious_id,a.date_) a
left join (
select MAX( LEFT(a.date_,4)) as B6,MAX(a.dept_read_id) as C6,MAX(a.dept_read) as D6,MAX(a.dept_write_id) as E6,MAX(a.dept_write) as F6,MAX(a.item_no) as H6,MAX(a.item_name) as I6,sum(a.budget_year) as J6,sum(a.adjust_year) as K6,sum(a.budget_mid_year) as L6,a.fictitious_id as G6, LEFT(a.fictitious_id,5) as G5, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3,max(c.NAME) as mc_E63,max(b.NAME) as mc_G60
from CWNDYJSBB a
left join ysxmdyb b
on (a.fictitious_id=b.ID)
left join zzjg c
on (a.dept_write_id=c.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5),a.fictitious_id) b
on ((a.G6=b.G6) AND (a.G5=b.G5) AND (a.G4=b.G4) AND (a.G3=b.G3))
left join (
select MAX( LEFT(a.date_,4)) as B5,MAX(a.dept_read_id) as C5,MAX(a.dept_read) as D5,MAX(a.dept_write_id) as E5,MAX(a.dept_write) as F5,MAX(a.item_no) as H5,MAX(a.item_name) as I5,sum(a.budget_year) as J5,sum(a.adjust_year) as K5,sum(a.budget_mid_year) as L5, LEFT(a.fictitious_id,5) as G5, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3,max(b.NAME) as mc_E53
from CWNDYJSBB a
left join zzjg b
on (a.dept_write_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5)) c
on ((a.G5=c.G5) AND (a.G4=c.G4) AND (a.G3=c.G3))
left join (
select sum(a.data_y) as M5,sum(a.data_j) as N5,a.date_ as M1, LEFT(a.fictitious_id,5) as G5, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3
from CWNDYJSBB a
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5),a.date_) d
on ((a.M1=d.M1) AND (a.G5=d.G5) AND (a.G4=d.G4) AND (a.G3=d.G3))
left join (
select sum(a.data_y) as M4,sum(a.data_j) as N4,a.date_ as M1, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3
from CWNDYJSBB a
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3),a.date_) e
on ((a.M1=e.M1) AND (a.G4=e.G4) AND (a.G3=e.G3))
left join (
select MAX( LEFT(a.date_,4)) as B4,MAX(a.dept_read_id) as C4,MAX(a.dept_read) as D4,MAX(a.dept_write_id) as E4,MAX(a.dept_write) as F4,MAX(a.item_no) as H4,MAX(a.item_name) as I4,sum(a.budget_year) as J4,sum(a.adjust_year) as K4,sum(a.budget_mid_year) as L4, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3,max(b.NAME) as mc_E43
from CWNDYJSBB a
left join zzjg b
on (a.dept_write_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3)) f
on ((a.G4=f.G4) AND (a.G3=f.G3))
left join (
select MAX( LEFT(a.date_,4)) as B3,MAX(a.dept_read_id) as C3,MAX(a.dept_read) as D3,MAX(a.dept_write_id) as E3,MAX(a.dept_write) as F3,MAX(a.item_no) as H3,MAX(a.item_name) as I3,sum(a.budget_year) as J3,sum(a.adjust_year) as K3,sum(a.budget_mid_year) as L3, LEFT(a.fictitious_id,1) as G3,max(b.NAME) as mc_E33
from CWNDYJSBB a
left join zzjg b
on (a.dept_write_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1)) g
on (a.G3=g.G3)
left join (
select sum(a.data_y) as M3,sum(a.data_j) as N3,a.date_ as M1, LEFT(a.fictitious_id,1) as G3
from CWNDYJSBB a
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1),a.date_) h
on ((a.M1=h.M1) AND (a.G3=h.G3))) a
inner join (
select * from ( select sum(a.data_y) as M6,sum(a.data_j) as N6,a.fictitious_id as G6, LEFT(a.fictitious_id,5) as G5, LEFT(a.fictitious_id,3) as G4, LEFT(a.fictitious_id,1) as G3,max(b.NAME) as mc_G61
from CWNDYJSBB a
left join ysxmdyb b
on (a.fictitious_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5),a.fictitious_id ) as temp_ limit 1000) b
on (a.G6=b.G6 or (a.G6 is null and b.G6 is null)) and (a.G5=b.G5 or (a.G5 is null and b.G5 is null)) and (a.G4=b.G4 or (a.G4 is null and b.G4 is null)) and (a.G3=b.G3 or (a.G3 is null and b.G3 is null))
inner join (
select * from ( select sum(a.data_y) as M6,sum(a.data_j) as N6,a.date_ as M1
from CWNDYJSBB a
left join ysxmdyb b
on (a.fictitious_id=b.ID)
where (a.dept_write_id = '010101')
group by a.date_ ) as temp_ limit 50) c
on (a.M1=c.M1 or (a.M1 is null and c.M1 is null))
2021-10-14 12:43:40 当前连接池为【erp_mxk】，执行SQL:
select count(*) as cn_
from (
select sum(a.data_y) as M6
from CWNDYJSBB a
left join ysxmdyb b
on (a.fictitious_id=b.ID)
where (a.dept_write_id = '010101')
group by LEFT(a.fictitious_id,1), LEFT(a.fictitious_id,3), LEFT(a.fictitious_id,5),a.fictitious_id) a
2021-10-14 12:43:40 SQL执行完毕，查询出175条数据，耗时：1秒660毫秒（开始时间：2021-10-14 12:43:38.902；结束时间：2021-10-14 12:43:40.562）；其中生成SQL耗时0毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：0毫秒；执行查询sql耗时：1秒628毫秒；执行计数sql耗时：16毫秒；
2021-10-14 12:43:40 在并行计算线程池中，完成计算表格GRID1第1个分析区（0.0.16.6）！
================GRID1 END================
2021-10-14 12:43:40.577 执行查询耗时1秒691毫秒。（内存情况：FREE=10.5G TOTAL=16G MAX=16G）
2021-10-14 12:43:40.608 构造结果表耗时31毫秒。
2021-10-14 12:43:40.608 计算“B93097”耗时1秒722毫秒。（内存情况：FREE=10.5G TOTAL=16G MAX=16G）[attach]37262[/attach]

你把上面三行删掉就没有问题了.

在显示表达式那么写个if判断。把三个汇总值改一下。问题不大。因为你维表是层级维。报表截取维表ID的2位一汇总。然后你在显示ID就获取到了截取的ID。