我的位置：首页 › 大数据分析-亿信BI › BI-问题求助 › 报表计算时如何关联上维表?

[亿信BI4.5] 报表计算时如何关联上维表?

复制链接 | 收藏本帖

4850

: book思议数据小白Lv1

发表于2021-3-29 11:26

悬赏4

已解决

楼主

select sum(a.ZC_CUR_BAL) as E5,sum(a.ZC_AVG_BAL) as F5,sum(a.ZC_CUR_RATE*100) as G5,sum(case when a.M_DAYS=0 then null else (case when a.ZC_AVG_BAL=0 then null else a.ZC_CUR_INTR_IN/a.ZC_AVG_BAL end )/a.M_DAYS end *365*100) as I5,sum(case when a.ZC_AVG_BAL*a.M_DAYS=0 then null else (-a.ZC_FTP_NET)/(a.ZC_AVG_BAL*a.M_DAYS) end *100*360) as K5,sum(a.FZ_CUR_BAL) as L5,sum(a.FZ_AVG_BAL) as M5,sum(a.FZ_CUR_RATE*100) as N5,sum(case when a.M_DAYS=0 then null else (case when a.FZ_AVG_BAL=0 then null else a.FZ_CUR_INTR_IN/a.FZ_AVG_BAL end )/a.M_DAYS end *365*100) as P5,sum(case when a.FZ_AVG_BAL*a.M_DAYS=0 then null else a.FZ_FTP_NET/(a.FZ_AVG_BAL*a.M_DAYS) end *36000) as R5,a.CUST_NAME as D5,a.CUST_CODE as C5,a.PJNAME as A5
from V_RPT_PA_CUST_RANK_CS a
,T_RPT_JGWD_UP b
where (A.ORG_CODE=B.ORGID_(+)) and ((a.DATA_DATE = '2021-01') AND (a.PJCODE = '21' or a.PJCODE = '22' or a.PJCODE = '23' or a.PJCODE = '24' or a.PJCODE = '25' or a.PJCODE = '26' or a.PJCODE = '27' or a.PJCODE = '31' or a.PJCODE = '32') AND ((b.UPID1_ = '05' and b.UPID0_ = '0100')) AND (a.ZC_AVG_BAL >= 0) AND (a.ZC_AVG_BAL <= 999999999999999) AND (a.FZ_AVG_BAL >= 0) AND (a.FZ_AVG_BAL <= 999999999999999))
group by a.PJNAME,a.CUST_CODE,a.CUST_NAME

像生成的这个sql,如何在报表生成sql时再添加个其他维表的关联?

最近看过此主题的会员

最佳答案

: xxxl

发表于2021-3-29 11:26

丨

只看该作者

丨

取消关注该作者的回复

book思议发表于 2021-3-29 11:40
做了一个维下拉参数组件来筛选T_RPT_PJWD_DG维表里的值~但是我看报表生成的sql不关联这个维表~ ...

就是设置维下拉，然后用维下拉对报表进行过滤对吧
可以写过滤条件或者是勾选维下拉的自动过滤来做
这里有过滤条件的教学视频https://www.esensoft.com/video/play/code/NjU%3D.html
和帮助文档https://bbs.esensoft.com/thread-128067-1-1.html

QQ空间微信