[ABI 5.2] 数据级次权限不生效的问题

查一下生成的sql呢

2022-03-21 14:13:50.029 开始计算报表：A001（内存情况：FREE=5G TOTAL=6.2G MAX=20.9G）
2022-03-21 14:13:50.030 引用的主题表 管理部门管理费预算表
2022-03-21 14:13:50.031 查询的数据级次范围：没有做限制
================GRID7================
2022-03-21 14:13:50.031 在并行计算线程池中，开始计算表格GRID7的第1个分析区（0.0.74.2）
2022-03-21 14:13:50 正在生成SQL...
2022-03-21 14:13:50 计算表格GRID7
2022-03-21 14:13:50 生成SQL耗时14毫秒
2022-03-21 14:13:50 当前连接池为【DEFAULT_SYS_PM_res_1】执行SQL:
select * from ( select MAX(a.idmix) as C2,MAX(a.gl_nysyb_yjjg1) as D2,MAX(a.gl_ejjg2) as E2,MAX(a.gl_sjjg3) as F2,MAX(a.gl_sjjg4) as G2,MAX(a.gl_bm) as H2,MAX(DATE_FORMAT(a.gl_rq, '%Y-%m-%d')) as I2,MAX(DATE_FORMAT(a.gl_yf, '%Y-%m')) as J2,MAX(DATE_FORMAT(a.gl_jd, '%Y-%m')) as K2,MAX(DATE_FORMAT(a.gl_bn, '%Y-%m')) as L2,MAX(DATE_FORMAT(a.gl_nf, '%Y')) as M2,MAX(a.zblx) as N2,sum(a.gl_bmglfyhj) as O2,sum(a.gl_glryrs) as P2,sum(a.gl_glrycq) as Q2,sum(a.gl_glryxchj) as R2,sum(a.gl_glryxc_gz) as S2,sum(a.gl_glryxc_qtxctqdwxyj) as T2,sum(a.gl_glbmfy_bghc_bgypf) as U2,sum(a.gl_glbmfy_ysf) as V2,sum(a.gl_glbmfy_pbtff) as W2,sum(a.gl_glbmfy_sbf) as X2,sum(a.gl_glbmfy_dhf) as Y2,sum(a.gl_glbmfy_jjdqshyp) as Z2,sum(a.gl_glbumfy_clf) as AA2,sum(a.gl_glbmfy_sf) as AB2,sum(a.gl_glbmfy_qnf) as AC2,sum(a.gl_glbmfy_ryf) as AD2,sum(a.gl_glbmfy_rqf) as AE2,sum(a.gl_glbmsbxh_df) as AF2,sum(a.gl_glbmfy_jdsjzxzjbgbzf) as AG2,sum(a.gl_glbmfy_ggxcf) as AH2,sum(a.gl_glbmfy_gldgdzczjfcsblgdzc) as AI2,sum(a.gl_glbmfy_gldgdzcyzcsblgdzc) as AJ2,sum(a.gl_glbmfy_sbxh) as AK2,sum(a.gl_glbmsbxh_sbzlf) as AL2,sum(a.gl_glbmsbxh_xlf) as AM2,sum(a.gl_glbmsbxh_wwjxf) as AN2,sum(a.gl_glbmsbxh_sbyz) as AO2,sum(a.gl_glbmsbxh_zysbyz) as AP2,sum(a.gl_glbmsbxh_zlsbyz) as AQ2,sum(a.gl_glbmsbxh_zjf) as AR2,sum(a.gl_glbmfy_txjwlf) as AS2,sum(a.gl_glbmfy_yszxfbhpgf) as AT2,sum(a.gl_glbmfy_sjf) as AU2,sum(a.gl_glbmfy_rj_xxhfwf) as AV2,sum(a.gl_glbmfy_jwxffwy) as AW2,sum(a.gl_glbmfy_sybxf) as AX2,sum(a.gl_glbmfy_lhf) as AY2,sum(a.gl_glbmfy_pwyjhbxgfy) as AZ2,sum(a.gl_glbmfy_ckqznf) as BA2,sum(a.gl_glbmfy_ckqtx) as BB2,sum(a.gl_glbmfy_tdtx_fzwbcf) as BC2,sum(a.gl_glbmfy_tdzlf) as BD2,sum(a.gl_glbmfy_flzxf) as BE2,sum(a.gl_glbmfy_ssf) as BF2,sum(a.gl_glbmfy_dwpcf) as BG2,sum(a.gl_glbmfy_clf) as BH2,sum(a.gl_glbmfy_hyf) as BI2,sum(a.gl_glbmfy_zdf) as BJ2,sum(a.gl_glbmfy_ygcjf) as BK2,sum(a.gl_glbmfy_gwycyz) as BL2,sum(a.gl_glbmfy_gwyczj) as BM2,sum(a.gl_glbmfy_gwycbxsf) as BN2,sum(a.gl_glbmfy_byfwxf) as BO2,sum(a.gl_glbmfy_gwycry) as BP2,sum(a.gl_glbmfy_gwyczlf) as BQ2,sum(a.gl_glbmfy_dshhf) as BR2,sum(a.gl_glbmfy_sjglf) as BS2,sum(a.gl_glbmfy_pp_zlf) as BT2,sum(a.gl_glbmfy_qtglfy) as BU2,sum(a.gl_kjyffy) as BV2,a.id as A2,max(f.NAME) as mc_D21,max(e.NAME) as mc_E22,max(d.NAME) as mc_F23,max(c.NAME) as mc_G24,max(b.NAME) as mc_H25
from gl_bmglf_ysb a
left join dm_glbmzjzg b
on (a.gl_bm=b.ID)
left join dm_glbmzjzg c
on (a.gl_sjjg4=c.ID)
left join dm_glbmzjzg d
on (a.gl_sjjg3=d.ID)
left join dm_glbmzjzg e
on (a.gl_ejjg2=e.ID)
left join dm_glbmzjzg f
on (a.gl_nysyb_yjjg1=f.ID)
where ((a.gl_nysyb_yjjg1 like '01011306%') AND (a.gl_nf <> 0))
group by a.id ) as temp_ limit 50
2022-03-21 14:13:50 SQL执行完毕，查询出0条数据，耗时：19毫秒（开始时间：2022-03-21 14:13:50.053；结束时间：2022-03-21 14:13:50.072）；其中生成SQL耗时14毫秒；初始获取连接耗时：0毫秒；查询准备总耗时：2毫秒；执行查询sql耗时：3毫秒；
2022-03-21 14:13:50.072 在并行计算线程池中，完成计算表格GRID7第1个分析区（0.0.74.2）
================GRID7 END================
2022-03-21 14:13:50.078 执行查询耗时51毫秒。（内存情况：FREE=5G TOTAL=6.2G MAX=20.9G）
2022-03-21 14:13:50.105 构造结果表耗时27毫秒
2022-03-21 14:13:50.105 计算“A001”耗时78毫秒。（内存情况：FREE=5G TOTAL=6.2G MAX=20.9G）

过滤主要是在这一段sql哈，您看下数据对应上了嘛

经过测试发现如果只绑定第四级的字段是可以实现您的需求的，
您可以只绑定第四级字段，其他三个字段用dim或diminf函数来取出文字

截图202203221546405148.png (37.14 KB, 下载次数: )

下载附件

2022-3-22 15:46 上传