-
-
touchi4 初学数据Lv2
发表于2023-7-21 15:41
悬赏100
已解决
最近看过此主题的会员
问题：交叉浮动，纵向为组织浮动，横向为科目浮动，设置分页未生效
解决方案：
交叉浮动不影响分页设置，原问题是因为报表中使用了sql数据源、补足维数据，以及报表中关联全部使用全连接。
建议根据补足维的维表新建主题表，带出需显示的数据；整个报表设定一个主表，其他指标都根据主表左连接。
21个回答
分页设置100行后计算结果截图看看呢？
chestnut 发表于 2023-7-21 18:12
分页设置100行后计算结果截图看看呢？
结果就是一楼的结果，超出100行，且超出的行全是0
touchi4 发表于 2023-7-21 18:36
结果就是一楼的结果，超出100行，且超出的行全是0
可以查看下报表的日志，有报表计算时自动生成的sql，可以看看是哪里的原因~
2023-07-21 16:34:50 当前连接池为【dw】，执行SQL:
select a.T5 as T5,a.V5 as V5,a.Y5 as Y5,a.Z5 as Z5,a.AA5 as AA5,a.AD5 as AD5,a.AE5 as AE5,a.T1 as T1,a.E5 as E5,a.mc_T10 as mc_T10,a.mc_E51 as mc_E51,a.drank1 as drank1,a.drank2 as drank2,max(drank1) over() as maxrankcnt1,max(drank2) over() as maxrankcnt2
from (
select a.T5 as T5,a.V5 as V5,a.Y5 as Y5,a.Z5 as Z5,a.AA5 as AA5,a.AD5 as AD5,a.AE5 as AE5,a.T1 as T1,a.E5 as E5,a.mc_T10 as mc_T10,a.mc_E51 as mc_E51,dense_rank() over(order by E5 asc nulls first) as drank1,dense_rank() over(order by T1 asc nulls first) as drank2
from (
select sum(a.CUR_ADJ_BUG) as T5,sum(a.ACCRUAL_ADJ) as V5,sum(a.YEAR_ADD_ADJ_BUG) as Y5,sum(a.YEAR_ADD_FIRST_BUG) as Z5,sum(a.YEAR_ACCUM) as AA5,sum(a.ALL_YEAR_ADJ_BUG) as AD5,sum(a.ALL_YEAR_FIRST_BUG) as AE5,b.LV1_ORG_CODE as T1,c.MIXID as E5,max(b.LV1_ORG_NAME) as mc_T10,max(c.NAME_) as mc_E51
from TS_MANAGEMENT_OPERATION_INDEX_D_202106 a
,DIM_SUBJECT_BUDGET_ORDER_MIX c
,F_DIM_ORG_COSTCENTER_D_ALL_TEMP b
where (C.ID_(+)=A.SUBJECT_BUDGET) and (A.ORG_CODE=B.ORG_CODE(+)) and ((a.LOAD_DATE = '20230720') AND ((b.LV0_ORG_CODE = 'SMFW-Z00-000-00-00')) AND (a.CLARIFY_RULE = '无抵消') AND (a.YEARMONTH = '202306') AND (c.SUBJECT_LEVEL <= 6))
group by c.MIXID,b.LV1_ORG_CODE) a) a
where (a.drank1 <= 100 and a.drank1 > 0 and a.drank2 <= 200 and a.drank2 > 0)
order by a.E5 nulls first,a.T1 nulls first
touchi4 发表于 2023-7-21 18:45
2023-07-21 16:34:50 当前连接池为【dw】，执行SQL:
select a.T5 as T5,a.V5 as V5,a.Y5 as Y5,a.Z5 as Z5, ...
这个drank导致的 他包在里面了 怎样才能在最外层设置分页呢
touchi4 发表于 2023-7-21 18:46
这个drank导致的 他包在里面了 怎样才能在最外层设置分页呢
这个是自动生成的，和报表的设计有关。看报表的截图，科目层级和科目名称是用的sql数据源吗？
方便导出表样吗，我这边看看？
这个是报表，不能正常分页，能帮忙看下吗
分析表_20230725_142204.zip
(108.81 KB, 下载次数: )
