BIEE XML文件

最新推荐文章于 2018-02-02 13:40:11 发布

原创最新推荐文章于 2018-02-02 13:40:11 发布 · 683 阅读

0 ·

CC 4.0 BY-SA版权

BIEE11g 专栏收录该内容

19 篇文章

订阅专栏

Proxy功能：

<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">
<WebMessageTable system="SecurityTemplates" table="Messages">
<WebMessage name="LogonParamSQLTemplate">
<XML>
<logonParam name="RUNAS">
<getValues>EXECUTE PHYSICAL CONNECTION POOL "NN Act As Proxy OLAP"."NN Proxy Connection Pool" SELECT TARGET_LOGIN from WC_PROXY_USERS_G where UPPER(PROXY_LOGIN)=UPPER('@{USERID}')</getValues>
<verifyValue>EXECUTE PHYSICAL CONNECTION POOL "NN Act As Proxy OLAP"."NN Proxy Connection Pool" SELECT TARGET_LOGIN from WC_PROXY_USERS_G where UPPER(PROXY_LOGIN) =UPPER('@{USERID}') and UPPER(TARGET_LOGIN)=UPPER('@{VALUE}')</verifyValue>
<getDelegateUsers>EXECUTE PHYSICAL CONNECTION POOL "NN Act As Proxy OLAP"."NN Proxy Connection Pool" SELECT PROXY_LOGIN, PROXY_LEVEL from WC_PROXY_USERS_G where UPPER(TARGET_LOGIN) =UPPER('@{USERID}')</getDelegateUsers>
</logonParam>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>

回写功能

<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="flag">
<XML>
<writeBack connectionPool="Oracle Data Warehouse Connection Pool">
<insert>INSERT INTO WC_GLOBAL_ETL_RUN_S VALUES(SYSDATE,'@1','VALUEOF(NQ_SESSION.USER)',SYSDATE)</insert>
<update>INSERT INTO WC_GLOBAL_ETL_RUN_S VALUES(SYSDATE,'@1','VALUEOF(NQ_SESSION.USER)',SYSDATE)</update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>