前台页面出报表要2分钟，后台sql就30几秒
0
前台抓出来的sql是这样的。
维度：月份，事业部id,事业部名称。指标：销售金额
SAWITH0 AS (select sum(T57638.MEASURE_METRIC) as c1,
T62416.ORG_NAME as c2,
T62416.ORG_NUM as c3,
cast(substr(T3506.PER_NAME_MONTH , 8 , 2) as INTEGER ) as c4
from
W_BUSN_ENTITY_D T62416 /* DIM_W_BUSN_ENTITY_D_ZK */ ,
W_MEASURE_KA_D T57595 /* DIM_W_MEASURE_KA_D */ ,
W_DAY_D T3506 /* DIM_W_DAY_D */ ,
W_KA_SALES_STORE_A T57638 /* FACT_W_KA_SALES_STORE_A */
where ( T3506.ROW_WID = T57638.DAY_WID
and T57595.MEASURE_ID = T57638.MEASURE_WID
and T57595.MEASURE_ID = 11002
and T57638.BD_WID = T62416.ROW_WID
and T57638.MEASURE_WID = 11002 and (T62416.ORG_NUM in ('02', '03', '04', '05')) )
group by T62416.ORG_NAME, T62416.ORG_NUM, cast(substr(T3506.PER_NAME_MONTH , 8 , 2) as INTEGER )
)
select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4, D1.c5 as c5 from ( select distinct 0 as c1,
D1.c2 as c2,
D1.c3 as c3,
D1.c4 as c4,
D1.c1 as c5
from
SAWITH0 D1
order by c4, c3, c2 ) D1 where rownum <= 10000000
维度：月份，事业部id,事业部名称。指标：销售金额
SAWITH0 AS (select sum(T57638.MEASURE_METRIC) as c1,
T62416.ORG_NAME as c2,
T62416.ORG_NUM as c3,
cast(substr(T3506.PER_NAME_MONTH , 8 , 2) as INTEGER ) as c4
from
W_BUSN_ENTITY_D T62416 /* DIM_W_BUSN_ENTITY_D_ZK */ ,
W_MEASURE_KA_D T57595 /* DIM_W_MEASURE_KA_D */ ,
W_DAY_D T3506 /* DIM_W_DAY_D */ ,
W_KA_SALES_STORE_A T57638 /* FACT_W_KA_SALES_STORE_A */
where ( T3506.ROW_WID = T57638.DAY_WID
and T57595.MEASURE_ID = T57638.MEASURE_WID
and T57595.MEASURE_ID = 11002
and T57638.BD_WID = T62416.ROW_WID
and T57638.MEASURE_WID = 11002 and (T62416.ORG_NUM in ('02', '03', '04', '05')) )
group by T62416.ORG_NAME, T62416.ORG_NUM, cast(substr(T3506.PER_NAME_MONTH , 8 , 2) as INTEGER )
)
select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4, D1.c5 as c5 from ( select distinct 0 as c1,
D1.c2 as c2,
D1.c3 as c3,
D1.c4 as c4,
D1.c1 as c5
from
SAWITH0 D1
order by c4, c3, c2 ) D1 where rownum <= 10000000
没有找到相关结果
重要提示：提问者不能发表回复，可以通过评论与回答者沟通，沟通后可以通过编辑功能完善问题描述，以便后续其他人能够更容易理解问题.
1 个回复
匆匆 - 拔剑浴血幕，只为红颜故、BIEE高级工程师 2015-06-16 回答
赞同来自: