OBIEE 11G回写插入XML [英] OBIEE 11G writeback Insert XML

问题描述

我正在创建XML，以便使用OBIEE 11g中的写回功能将值插入表中.这是我的XML编码，并且收到一条错误消息，提示....系统无法读取回写模板'STG_DE_ACCOUNTS_RECEIVABLE_insert'.请与系统管理员联系."

I am creating an XML for inserting values into a table using the writeback feature in OBIEE 11g. Here is my XML coding and I am getting an error message that says...."The system is unable to read the Write Back Template 'STG_DE_ACCOUNTS_RECEIVABLE_insert'. Please contact your system administrator."

<?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="STG_DE_ACCOUNTS_RECEIVABLE_insert">
      <XML>
         <writeBack connectionPool="LCS_CP_VAR">

<insert>INSERT INTO STG_DE_ACCOUNTS_RECEIVABLE(AL_90_RCVBL, AL_CUR_RCVBL, AL_TOT_RCVBL) Values 
(@{c3},@{c4},@{c5}) </insert>


<update></update>
         </writeBack>
      </XML>
   </WebMessage>
</WebMessageTable>
</WebMessageTables>

推荐答案

1. 步骤1:启用回写.在instanceconfig.xml文件的serverinstance标记内添加LightWriteback标记.

1. Step 1: Enable Write Back. Add the LightWriteback tag within the serverinstance tag of the instanceconfig.xml file.

• 文件路径:$ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1
• 添加以下标签:<LightWriteback>true</LightWriteback>
• 重新启动OracleBIPresentationServicesComponent

• File path: $ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1
• Add the following tag: <LightWriteback>true</LightWriteback>
• Restart OracleBIPresentationServicesComponent

步骤2:向您正在使用的用户/组/角色添加WriteBack特权.

Step2: Add WriteBack privileges to the user/Group/Role you are using.

第3步:写回模板.

• 标识要引用的列.我们可以在XML定义中使用列位置或列ID来使用它们.

• Identify the colums that are to be referenced. we can use the colum position or by colum id as you see them in the XML definition.

您必须在模板中同时包含插入和更新语句.

You must include both insert and update statements in the template.

最好是包含commit语句:<postUpdate>COMMIT</postUpdate>.

It is the best practice to include the commit statement: <postUpdate>COMMIT</postUpdate>.

模板应位于以下位置:$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

The template should be located here: $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

完成所有回写设置后，需要在条件"选项卡上设置位于字段列属性"上的启用回写"功能.

Once you are done with all writeback settings, you need to set 'Enable Write Back' feature located on Column Properties of the field, from the criteria tab.

此链接显示了一个示例XML回写文件: http://obieetutorialguide.blogspot.com/2015/04/write-back-setting-in-obiee-11g.html

This link shows an example XML writeback file: http://obieetutorialguide.blogspot.com/2015/04/write-back-setting-in-obiee-11g.html

这篇关于OBIEE 11G回写插入XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！