帆软与SAP HANA数仓传参模板，可选与必选

淀粉帅哥

已于 2024-01-17 09:48:50 修改

阅读量426

点赞数 6

分类专栏： FineBI SAP BW HANA 文章标签：前端 finebi

于 2024-01-17 09:47:25 首次发布

本文链接：https://blog.csdn.net/weixin_42102153/article/details/135641679

版权

SAP BW 同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

HANA

2 篇文章 0 订阅

订阅专栏

FineBI

1 篇文章 0 订阅

订阅专栏

1、帆软与HANA数据库需要注意要带""否则报错

2、开始时间与结束时间为必选

3、项目名称以及SN、订单都是可选，可为空

如下代码：

SELECT
"ZDEVI_NO" AS "设备编号"
,"ZSN_REAL" AS "产品条码"
,"ZXM_NAME" AS "项目名称"
,TO_TIMESTAMP("ZST_DAT"||"ZST_TIME") AS  "开始时间"
,TO_TIMESTAMP("ZEND_DAT"||"ZEND_TIME") AS  "结束时间"
,SECONDS_BETWEEN(TO_TIMESTAMP("ZST_DAT"||"ZST_TIME"),TO_TIMESTAMP("ZEND_DAT"||"ZEND_TIME"))
FROM
"_SYS_BIC"."system-local.bw.bw2hana.query.xxxxxxx001"
WHERE "ZST_DAT" >= REPLACE('${ZST_DAT}','-','')
AND "ZST_DAT" < REPLACE('${ZEND_DAT}','-','')
${IF(LEN(ZXM_NAME)==0,"","AND \"ZXM_NAME\" IN ('"+ZXM_NAME+"')")}
${IF(LEN(ZSN_REAL)==0,"","AND \"ZSN_REAL\" IN ('"+ZSN_REAL+"')")}
${IF(LEN(ZSP_ORDER)==0,"","AND \"ZSP_ORDER\" IN ('"+ZSP_ORDER+"')")}