币种报表怎么展示比较优雅？业务要求按历史实时汇率折算，在BI...

要做一个财务的销售明细表。明细里记录的金额有美元、欧元、人民币。
要求在报表上增加一列“折合人民币总额”。难点在于：必须按订单发生当天的历史汇率来算，不能用今天的汇率统一乘。
目前系统里有一张“每日汇率表”（包含日期、币种、汇率）。
如果在底层ETL处理，每天跑一次太麻烦。如果在数据集里写原生SQL（用CASE WHEN关联汇率表），不仅查询慢，而且前端大数据量下很容易超时。
请教一下，在SmartBI里，有没有内置的宏代码函数，或者参数处理逻辑，能实现“动态查表乘汇率”的功能？或者推荐用“数据模型”里的自定义计算字段来实现？

谢谢
weibo.com/ttarticle/p/show?id=2309405365594131398860j4w9jiy
weibo.com/ttarticle/p/show?id=2309405365594416611502ht9px690
weibo.com/ttarticle/p/show?id=2309405365584614785593202611158isc
weibo.com/ttarticle/p/show?id=2309405365584178315370vfw0a1j
weibo.com/ttarticle/p/show?comment=1&id=230940536558525625182320261115eop
weibo.com/ttarticle/p/show?id=230940536558509686815920261115yl3w
weibo.com/ttarticle/p/show?comment=1&id=23094053655938883912732026111517r
weibo.com/ttarticle/p/show?id=2309405365593489670494gaosf5g
weibo.com/ttarticle/p/show?comment=1&id=2309405365594538246280pcst7at
weibo.com/ttarticle/p/show?comment=1&id=2309405365585382080629uzhx5gdd
weibo.com/ttarticle/p/show?id=230940536558394369639620261115vsr
weibo.com/ttarticle/p/show?comment=1&id=230940536558542009164820261115q6m9
weibo.com/ttarticle/p/show?comment=1&id=2309405365584979689731tkrxghx
weibo.com/ttarticle/p/show?id=2309405365584136634452hoid96
weibo.com/ttarticle/p/show?comment=1&id=230940536559437466848620261115hogs
weibo.com/ttarticle/p/show?id=230940536558493774690220261115rq3i
weibo.com/ttarticle/p/show?comment=1&id=230940536558517655993220261115lwcu
weibo.com/ttarticle/p/show?comment=1&id=2309405365584081846618eq6syce6
weibo.com/ttarticle/p/show?comment=1&id=230940536559429523881020261115o9e
weibo.com/ttarticle/p/show?id=230940536559445855446220261115aic1
weibo.com/ttarticle/p/show?comment=1&id=2309405365593410240743yehczj
weibo.com/ttarticle/p/show?id=2309405365585059119316hm3y1eu
weibo.com/ttarticle/p/show?id=230940536559401395814720261115ptrx
weibo.com/ttarticle/p/show?id=23094053655846944771432026111580m
weibo.com/ttarticle/p/show?id=2309405365585256251823202611152a8o
weibo.com/ttarticle/p/show?comment=1&id=230940536558502163257420261115ooo
weibo.com/ttarticle/p/show?comment=1&id=23094053655849377469025dvw0uf
weibo.com/ttarticle/p/show?comment=1&id=2309405365585340399691tfkzu53
weibo.com/ttarticle/p/show?id=230940536558482004385120261115gxo
weibo.com/ttarticle/p/show?id=2309405365594458554462ugrkfqt
weibo.com/ttarticle/p/show?id=2309405365593846186168202611159ot
weibo.com/ttarticle/p/show?id=2309405365593611567167a03u8xe
weibo.com/ttarticle/p/show?comment=1&id=230940536558417831537020261115rm6w
weibo.com/ttarticle/p/show?comment=1&id=2309405365594051969283ic1v6j
weibo.com/ttarticle/p/show?id=230940536559364905393820261115yny
weibo.com/ttarticle/p/show?comment=1&id=2309405365593451921544k04b32u
weibo.com/ttarticle/p/show?comment=1&id=2309405365585059119316sllekyga
weibo.com/ttarticle/p/show?id=23094053655852562518236nkxf7j
weibo.com/ttarticle/p/show?comment=1&id=230940536559445855446220261115nza
weibo.com/ttarticle/p/show?id=230940536558502163257420261115c9n
weibo.com/ttarticle/p/show?comment=1&id=2309405365585096868159cjvqr9y2
weibo.com/ttarticle/p/show?id=2309405365594295238810hquth6jg
weibo.com/ttarticle/p/show?id=230940536559345192154420261115gci
weibo.com/ttarticle/p/show?id=2309405365584694477143w4fqiz5
weibo.com/ttarticle/p/show?comment=1&id=230940536558435447613320261115ja37
weibo.com/ttarticle/p/show?id=2309405365584035971190kpv7ami5
weibo.com/ttarticle/p/show?id=23094053655846564660270fm7ywv
weibo.com/ttarticle/p/show?id=230940536558422052083420261115auxd
weibo.com/ttarticle/p/show?comment=1&id=2309405365593770950667x7q49x40
weibo.com/ttarticle/p/show?comment=1&id=230940536558469447714320261115dnp
weibo.com/ttarticle/p/show?comment=1&id=2309405365594295238810gm2i4n
weibo.com/ttarticle/p/show?comment=1&id=23094053655848999980503c263cb
weibo.com/ttarticle/p/show?comment=1&id=230940536558493774690220261115zcsr
weibo.com/ttarticle/p/show?id=230940536559341024074320261115ijr1
weibo.com/ttarticle/p/show?comment=1&id=230940536559397201524320261115jq3
weibo.com/ttarticle/p/show?id=2309405365594253033645vhwapnwk
weibo.com/ttarticle/p/show?id=2309405365584266658155ca5jphz
weibo.com/ttarticle/p/show?comment=1&id=2309405365585176559932eqj0x78b
weibo.com/ttarticle/p/show?comment=1&id=230940536558446798449920261115kjd
weibo.com/ttarticle/p/show?id=230940536558473641985820261115ovr
weibo.com/ttarticle/p/show?comment=1&id=2309405365593649053938sx7lxo7f
weibo.com/ttarticle/p/show?comment=1&id=230940536558497968973120261115o8w
weibo.com/ttarticle/p/show?id=230940536559433272552720261115212
weibo.com/ttarticle/p/show?id=2309405365585340399691xbtj1y
weibo.com/ttarticle/p/show?id=230940536558521876481520261115q588
weibo.com/ttarticle/p/show?id=2309405365584081846618202611150ncy
weibo.com/ttarticle/p/show?comment=1&id=2309405365583943696396202611158ez
weibo.com/ttarticle/p/show?comment=1&id=2309405365594051969283202611152a
weibo.com/ttarticle/p/show?comment=1&id=230940536558461478559320261115owne
weibo.com/ttarticle/p/show?id=230940536558477836333620261115pzah
weibo.com/ttarticle/p/show?comment=1&id=2309405365584136634452202611155vs
weibo.com/ttarticle/p/show?comment=1&id=230940536559380869963820261115xklm
weibo.com/ttarticle/p/show?comment=1&id=230940536558513881100920261115zzk
weibo.com/ttarticle/p/show?comment=1&id=230940536559421554691920261115w5cb
weibo.com/ttarticle/p/show?id=23094053655936912589592026111526l
weibo.com/ttarticle/p/show?comment=1&id=230940536558482004385120261115v02
weibo.com/ttarticle/p/show?id=2309405365585138811009er753ld
weibo.com/ttarticle/p/show?id=2309405365584220520834e8ects6
weibo.com/ttarticle/p/show?id=230940536559380869963820261115p0s
weibo.com/ttarticle/p/show?comment=1&id=23094053655851388110093f7ze8k
weibo.com/ttarticle/p/show?comment=1&id=2309405365584035971190vrzk1en
weibo.com/ttarticle/p/show?comment=1&id=23094053655853820806292026111567f
weibo.com/ttarticle/p/show?id=230940536559449656546420261115cfvo
weibo.com/ttarticle/p/show?comment=1&id=230940536559384618616820261115qy46
weibo.com/ttarticle/p/show?id=230940536559405196928320261115vv6y
weibo.com/ttarticle/p/show?comment=1&id=230940536559364905393820261115bxty
weibo.com/ttarticle/p/show?id=23094053655938883912733d4dz2
weibo.com/ttarticle/p/show?id=23094053655939720152436r6bfis
weibo.com/ttarticle/p/show?id=2309405365585218764815nvv1os9
weibo.com/ttarticle/p/show?comment=1&id=230940536559433272552720261115qtck
weibo.com/ttarticle/p/show?comment=1&id=230940536558534039969120261115du9h
weibo.com/ttarticle/p/show?id=2309405365584862249055so6s45c0
weibo.com/ttarticle/p/show?comment=1&id=23094053655847783633362026111592
weibo.com/ttarticle/p/show?id=2309405365585176559932dk9urpaf
weibo.com/ttarticle/p/show?id=2309405365594496565464ap67m79
weibo.com/ttarticle/p/show?comment=1&id=230940536558521876481520261115xam0
weibo.com/ttarticle/p/show?id=230940536559348967049420261115xlj
weibo.com/ttarticle/p/show?comment=1&id=230940536558542009164877gwgb32
weibo.com/ttarticle/p/show?id=2309405365593934528561202611159wh
weibo.com/ttarticle/p/show?id=230940536558486224905520261115n1uk
weibo.com/ttarticle/p/show?comment=1&id=230940536558431279516820261115d3n
weibo.com/ttarticle/p/show?id=230940536559408971800920261115kx07
weibo.com/ttarticle/p/show?comment=1&id=2309405365585256251823i8ngktb
weibo.com/ttarticle/p/show?comment=1&id=2309405365584656466027tfel0cn8
weibo.com/ttarticle/p/show?id=2309405365584518054110po2q23h
weibo.com/ttarticle/p/show?id=2309405365584614785593j5i3kgng
weibo.com/ttarticle/p/show?id=230940536559429523881020261115sh6c
weibo.com/ttarticle/p/show?id=2309405365593972015243202611150ss
weibo.com/ttarticle/p/show?id=230940536558426665815520261115ju5u
weibo.com/ttarticle/p/show?comment=1&id=23094053655936912589599bijyh3
weibo.com/ttarticle/p/show?comment=1&id=230940536558486224905520261115y79e
weibo.com/ttarticle/p/show?comment=1&id=2309405365594332725527cftapsi
weibo.com/ttarticle/p/show?id=23094053655844679844990jnw2c57
weibo.com/ttarticle/p/show?comment=1&id=230940536559449656546420261115dfh6
weibo.com/ttarticle/p/show?id=2309405365593729007676202611150biv
weibo.com/ttarticle/p/show?comment=1&id=2309405365584518054110gapxyhx
weibo.com/ttarticle/p/show?comment=1&id=2309405365593770950667202611159mk
weibo.com/ttarticle/p/show?comment=1&id=230940536558441319657420261115fg8h
weibo.com/ttarticle/p/show?id=2309405365584820043851vq334w3
weibo.com/ttarticle/p/show?comment=1&id=2309405365583985639562abf27j
weibo.com/ttarticle/p/show?id=2309405365584413196574k644guk4
weibo.com/ttarticle/p/show?comment=1&id=23094053655935696242455w9dfzn
weibo.com/ttarticle/p/show?comment=1&id=23094053655938883912732v6oplfh
weibo.com/ttarticle/p/show?id=230940536559353187546520261115c2jx
weibo.com/ttarticle/p/show?id=2309405365593691258959z5qm32t
weibo.com/ttarticle/p/show?id=230940536558513881100920261115pl6
weibo.com/ttarticle/p/show?comment=1&id=230940536558489999805020261115xx3
weibo.com/ttarticle/p/show?id=230940536558534039969120261115ngl
weibo.com/ttarticle/p/show?id=230940536558497968973120261115gn8k
weibo.com/ttarticle/p/show?comment=1&id=2309405365584518054110202611159rys
weibo.com/ttarticle/p/show?comment=1&id=23094053655937290076767yrwmt7t
weibo.com/ttarticle/p/show?comment=1&id=23094053655940139581479m5485u7
weibo.com/ttarticle/p/show?comment=1&id=230940536558398563956220261115a9f9
weibo.com/ttarticle/p/show?id=2309405365593531875465vc4h0mv
weibo.com/ttarticle/p/show?comment=1&id=230940536558403597119020261115a5s
weibo.com/ttarticle/p/show?comment=1&id=2309405365594416611502jvuuorq
weibo.com/ttarticle/p/show?comment=1&id=230940536559393452856120261115bxi
weibo.com/ttarticle/p/show?id=230940536559384618616871xtcjqn
weibo.com/ttarticle/p/show?comment=1&id=230940536559345192154420261115cew
weibo.com/ttarticle/p/show?id=2309405365584467984499202611155eve
weibo.com/ttarticle/p/show?id=2309405365593808699638xdhfkyer
weibo.com/ttarticle/p/show?comment=1&id=23094053655848622490553opery7y
weibo.com/ttarticle/p/show?comment=1&id=230940536558426665815520261115wssa
weibo.com/ttarticle/p/show?comment=1&id=2309405365593934528561uop60nw
weibo.com/ttarticle/p/show?comment=1&id=230940536558408184661820261115d0x0
weibo.com/ttarticle/p/show?id=2309405365583985639562y55fs4f
weibo.com/ttarticle/p/show?comment=1&id=23094053655846147855932fq74bs
weibo.com/ttarticle/p/show?comment=1&id=2309405365585218764815ygmp3j8u
weibo.com/ttarticle/p/show?id=230940536559377095066776as9h
weibo.com/ttarticle/p/show?comment=1&id=230940536559356962424520261115cue
weibo.com/ttarticle/p/show?comment=1&id=230940536559413139886020261115ekf2
weibo.com/ttarticle/p/show?comment=1&id=230940536559369125895920261115zxzf
weibo.com/ttarticle/p/show?comment=1&id=2309405365594131398860un0n1tl
weibo.com/ttarticle/p/show?comment=1&id=230940536559361156716720261115snrr
weibo.com/ttarticle/p/show?id=2309405365593770950667202611152qpl
weibo.com/ttarticle/p/show?comment=1&id=230940536559353187546520261115k2n
weibo.com/ttarticle/p/show?comment=1&id=2309405365585059119316202611158e5m
weibo.com/ttarticle/p/show?id=230940536558542009164830jh185
weibo.com/ttarticle/p/show?comment=1&id=2309405365584354476133w75hlb5s
weibo.com/ttarticle/p/show?comment=1&id=2309405365584736419858cpk6wan
weibo.com/ttarticle/p/show?id=23094053655853820806291d7yy51
weibo.com/ttarticle/p/show?id=2309405365584312795168lex3cn8h
weibo.com/ttarticle/p/show?comment=1&id=2309405365593846186168w407tyzi
weibo.com/ttarticle/p/show?comment=1&id=230940536558422052083420261115b83q
weibo.com/ttarticle/p/show?comment=1&id=2309405365593489670494n5q4o1
weibo.com/ttarticle/p/show?id=2309405365585021632574rp72minb
weibo.com/ttarticle/p/show?id=230940536558538208062920261115lke1
weibo.com/ttarticle/p/show?id=230940536559388839127320261115mhz
weibo.com/ttarticle/p/show?comment=1&id=23094053655944965654645ma9bhk
weibo.com/ttarticle/p/show?comment=1&id=2309405365594374668486j42srnhz
weibo.com/ttarticle/p/show?id=2309405365593934528561qomgyhkv
weibo.com/ttarticle/p/show?comment=1&id=230940536558509686815920261115dp25
weibo.com/ttarticle/p/show?comment=1&id=23094053655940897180094i1exaw
weibo.com/ttarticle/p/show?id=230940536559441661150220261115w23a
weibo.com/ttarticle/p/show?id=2309405365593729007676ibnyi67n
weibo.com/ttarticle/p/show?id=230940536558457258032120261115u02h
weibo.com/ttarticle/p/show?comment=1&id=230940536559372900767620261115uu2r
weibo.com/ttarticle/p/show?id=2309405365584572580321yw0a2
weibo.com/ttarticle/p/show?id=2309405365594374668486202611157rre
weibo.com/ttarticle/p/show?id=230940536558465646602720261115mv7x
weibo.com/ttarticle/p/show?comment=1&id=2309405365584820043851b8lpiiay
weibo.com/ttarticle/p/show?id=230940536558398563956220261115ucre
weibo.com/ttarticle/p/show?comment=1&id=2309405365593531875465elhdq24
weibo.com/ttarticle/p/show?comment=1&id=230940536558457258032120261115n2l9
weibo.com/ttarticle/p/show?comment=1&id=2309405365584694477143uvxooz
weibo.com/ttarticle/p/show?id=23094053655849796897314dh8zyor
weibo.com/ttarticle/p/show?comment=1&id=2309405365584413196574cga4q95
weibo.com/ttarticle/p/show?id=2309405365584937746902gnhhvw4p
weibo.com/ttarticle/p/show?id=23094053655936490539382mrudqgw
weibo.com/ttarticle/p/show?id=2309405365594374668486jeiizvbt
weibo.com/ttarticle/p/show?comment=1&id=2309405365593972015243ma5f1es
weibo.com/ttarticle/p/show?id=2309405365594013958147qfz3tgf4
weibo.com/ttarticle/p/show?id=2309405365594332725527k2vteom
weibo.com/ttarticle/p/show?id=230940536558451805411020261115w00u
weibo.com/ttarticle/p/show?comment=1&id=2309405365584266658155g90l7ovf
weibo.com/ttarticle/p/show?id=2309405365584354476133xett18q
weibo.com/ttarticle/p/show?comment=1&id=2309405365583943696396zt6lbea
weibo.com/ttarticle/p/show?comment=1&id=230940536558529819444520261115982u
weibo.com/ttarticle/p/show?comment=1&id=2309405365594458554462ic70ui66
weibo.com/ttarticle/p/show?id=23094053655847364198584fjia0f0
weibo.com/ttarticle/p/show?comment=1&id=230940536559453824628020261115cxs
weibo.com/ttarticle/p/show?id=2309405365585096868159a374dpl
weibo.com/ttarticle/p/show?comment=1&id=230940536559425303364520261115dl5d
weibo.com/ttarticle/p/show?comment=1&id=2309405365584467984499sp7xxwi3
weibo.com/ttarticle/p/show?id=230940536558529819444520261115y9ct
weibo.com/ttarticle/p/show?comment=1&id=2309405365594253033645utdut5l
weibo.com/ttarticle/p/show?id=230940536558403597119020261115dwe5
weibo.com/ttarticle/p/show?comment=1&id=23094053655850216325748i6o7xu
weibo.com/ttarticle/p/show?id=2309405365593569624245202611157m54
weibo.com/ttarticle/p/show?comment=1&id=230940536559408971800920261115lxtw
weibo.com/ttarticle/p/show?id=230940536559421554691920261115ozb
weibo.com/ttarticle/p/show?id=2309405365594538246280tvvtkkk3
weibo.com/ttarticle/p/show?id=230940536558517655993220261115tjl7
weibo.com/ttarticle/p/show?comment=1&id=2309405365584312795168k7vnbl
weibo.com/ttarticle/p/show?id=230940536559361156716720261115pu0
weibo.com/ttarticle/p/show?id=2309405365583943696396gh9c1fe
weibo.com/ttarticle/p/show?id=230940536558417831537020261115s2ek
weibo.com/ttarticle/p/show?id=230940536558413663445220261115q2r7
weibo.com/ttarticle/p/show?comment=1&id=2309405365593489670494202611150d0i
weibo.com/ttarticle/p/show?id=2309405365594215546919omok7x0s
weibo.com/ttarticle/p/show?comment=1&id=230940536559341024074320261115v9v2
weibo.com/ttarticle/p/show?comment=1&id=2309405365584778363336qv8j82m
weibo.com/ttarticle/p/show?id=2309405365594051969283p6vzn1y8
weibo.com/ttarticle/p/show?id=230940536559453824628020261115soia
weibo.com/ttarticle/p/show?comment=1&id=230940536558413663445223bn8g7
weibo.com/ttarticle/p/show?id=230940536558489999805020261115u7v
weibo.com/ttarticle/p/show?comment=1&id=230940536558465646602720261115b2x
weibo.com/ttarticle/p/show?id=2309405365585298194445vj8gtp2o
weibo.com/ttarticle/p/show?comment=1&id=230940536558473641985820261115p2j
weibo.com/ttarticle/p/show?comment=1&id=2309405365584220520834kf94dbtr
weibo.com/ttarticle/p/show?id=2309405365593451921544u4craa4v
weibo.com/ttarticle/p/show?comment=1&id=2309405365585298194445jkwmcgt
weibo.com/ttarticle/p/show?comment=1&id=2309405365584178315370o323pds
weibo.com/ttarticle/p/show?id=2309405365584081846618rfp7zxa7
weibo.com/ttarticle/p/show?id=2309405365594131398860202611156e
weibo.com/ttarticle/p/show?id=230940536558542009164820261115rq3i
weibo.com/ttarticle/p/show?id=2309405365593569624245hv29m0l
weibo.com/ttarticle/p/show?comment=1&id=2309405365594215546919no9hyids
weibo.com/ttarticle/p/show?id=230940536558431279516820261115t2jv
weibo.com/ttarticle/p/show?id=230940536558441319657420261115z2fq
weibo.com/ttarticle/p/show?comment=1&id=2309405365593808699638wxkt2527
weibo.com/ttarticle/p/show?comment=1&id=230940536559441661150220261115wm3
weibo.com/ttarticle/p/show?id=2309405365584778363336fdmnfjqt
weibo.com/ttarticle/p/show?id=230940536559341024074389mon4wj
weibo.com/ttarticle/p/show?id=2309405365594089718009x6q5xh2
weibo.com/ttarticle/p/show?id=2309405365585059119316202611154y7
weibo.com/ttarticle/p/show?comment=1&id=230940536558457258032161vnvpw
weibo.com/ttarticle/p/show?id=23094053655843544761332026111598z
weibo.com/ttarticle/p/show?id=230940536559425303364520261115etc
weibo.com/ttarticle/p/show?id=23094053655848999980504r5tgv6
weibo.com/ttarticle/p/show?comment=1&id=2309405365593611567167uwomf324
weibo.com/ttarticle/p/show?comment=1&id=230940536559401395814720261115qujo