在OBIEE中写回表格 [英] Write Back Form in OBIEE

问题描述

我创建了一个包含XML模板的回写表单.有人可以让我知道我的代码有什么问题吗?所有回写功能均已启用，因此我认为表格中的语法无效.

I created a write back form that incorporates an XML template. Can somebody please let me know what is wrong with my code? All the write back features have been enabled so I believe my syntax in the form is not valid.

<?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="wb_stg_de_accounts_receivable">
      <XML>
         <writeBack connectionPool="LCS_CP_VAR">
            <insert> </insert>
            <update>UPDATE STG_DE_ACCOUNTS_RECEIVABLE SET AL_CUR_RCVBL=@2, MCAREA_90_RCVBL=@3 WHERE ENTITY_ID=@1</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

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

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

Step3:回写模板.

Step3:WriteBack Template.

标识要引用的列.我们可以在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

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

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中写回表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！