This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Jan 9, 2013 7:01 AM by 880411 RSS

OBIEE writeback

sivausin Newbie
Currently Being Moderated
Hi Experts,

I am trying the writeback option in OBIEE. I am following one of the forun link

http://oraclebizint.wordpress.com/2007/09/20/oracle-bi-ee-101332-write-back-option-budgetingplanning/

But However at step 6, where it is specified that an XML template will be created under {ORACLEBI}/web/customMessages folder. But there is such folder is not existing and the XML template files are created.


Your Inputs are appreciated


siva
  • 1. Re: OBIEE writeback
    646090 Expert
    Currently Being Moderated
    Hi Siva,

    You're really close but you missed the "msgdb" folder. Here's the correct path on a standard windows installation.


    C:\OracleBI\web\msgdb\customMessages


    Good luck!

    -Joe
  • 2. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi Joe,


    Thanks for you reply...

    I have created the WriteBack.xml file and it has the following ..

    <?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="WriteBack">
    <XML>
    <writeBack connectionPool="Connection Pool">
    <insert></insert>
    <update> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{C1} </update>
    </writeBack>
    </XML>
    </WebMessage>
    </WebMessageTable>
    </WebMessageTables>

    and my fact table structure is CREATE TABLE "GLOBAL"."C_SALES_FACT"
    (
    "RNUM" NUMBER,
    "COMP_KEY" VARCHAR2(42 BYTE),
    "MONTH_ID" NUMBER(5,0),
    "ITEM_ID" NUMBER(5,0),
    "SHIP_TO_ID" NUMBER(5,0),
    "CHANNEL_ID" NUMBER(5,0),
    "UNITS" NUMBER,
    "SALES" NUMBER,
    "COST" NUMBER
    );



    i am trying to update the table. But though I have created the XML template file and placed in OBIEEData\web\msgdb\customMessages folder. There is no update button appears in my OBIEE answers report.

    Please suggest how to proceed.


    Thanks and Regards
    Siva
  • 3. Re: OBIEE writeback
    646090 Expert
    Currently Being Moderated
    Hey Siva,

    Double check that you have completed steps 5 and 7 from OBIEE writeback.

    Which step are you having difficulties with? Have you tried bouncing the BI Server/Presentation Server/Java Host?

    -Joe
  • 4. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi Joe,

    I have got the button now, but i have another problem I think the last step.

    I have got the Update button, but when I am trying to update , it is giving the error message

    " The system is unable to read the Write Back Template 'WriteBack'. Please contact your system administrator. "


    here are the contents of my XML template WriteBack.XML file

    <?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="WriteBack">
    <XML>
    <writeBack connectionPool="Connection Pool">
    <update> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{C1} </update>
    <postUpdate>COMMIT</postUpdate>
    </writeBack>
    </XML>
    </WebMessage>
    </WebMessageTable>
    </WebMessageTables>



    Please suggest where I am doing mistake.

    Thanks and Regards
    Siva
  • 5. Re: OBIEE writeback
    577516 Expert
    Currently Being Moderated
    <?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="writeback">
    <XML>
    <writeBack connectionPool="Connection Pool">
    <insert> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{c1} </insert>
    <update> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{c1} </update>
    </writeBack>
    </XML>
    </WebMessage>
    </WebMessageTable>
    </WebMessageTables>
  • 6. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi,


    THanks for your reply. I updated the XML template with the changes that you had suggested, but still I get the same message. Any other inputs or suggestions would be appreciated.


    Thanks and Regards
    Siva
  • 7. Re: OBIEE writeback
    577516 Expert
    Currently Being Moderated
    did you use lowecase? did you place in right folder? did you restart services?
  • 8. Re: OBIEE writeback
    646090 Expert
    Currently Being Moderated
    Hi Siva,

    Double check that the name in "<WebMessage name="writeback">" is the exact same case as what you have in your report. i.e. it's writeback in the XML and then it cannot be WriteBack in the Report or Writeback or writeBack.

    Once you've confirmed the case, cycle all the services (bi, presentation, OC4J for good measure).

    You should be set!

    -Joe
  • 9. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi Joe,

    Thanks for the support.

    I want to clarify the statement " it's writeback in the XML and then it cannot be WriteBack in the Report" . If you see my XML contents it is mentioned as WriteBack at


    1. <WebMessage name="WriteBack">
    2. <WebMessageTable lang="en-us" system="WriteBack" table="Messages">

    and the name of the xml template is also WriteBack.XML



    <?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="WriteBack">
    <XML>
    <writeBack connectionPool="Connection Pool">
    <insert> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{c1} </insert>
    <update> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{C1} </update>
    <postUpdate>COMMIT</postUpdate>
    </writeBack>
    </XML>
    </WebMessage>
    </WebMessageTable>
    </WebMessageTables>


    ---Questions

    Q1. Do you want me to replace ' WriteBack ' to ' writeback ' ?
    Q2. what does this part of the statement "..then it cannot be WriteBack in the Report" mean ?


    I appreciate all you input and suggestions in working this happen.

    Thanks and Regards
    Siva
  • 10. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi mma1709,

    for the two lines in XML template is used W(caps)riteB(caps)ack. here is the following..

    <WebMessageTable lang="en-us" system="WriteBack" table="Messages">
    <WebMessage name="WriteBack">


    Apart from that, Yes I have placed in the right folder and I restart the services for every change I am making...


    Do you suggest to replace "WriteBack" to "writeback" in the above code ? Please suggest.



    Thanks and Regards
    Siva
  • 11. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi Joe / mma1709,

    I have somehow pass that error message , but got some error regarding the SQL statement specified. Here is the error message ......

    ------------------
    The system was unable to generate appropriate SQL. Please contact your system administrator.
    Error Details
    Template: ' UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{C1} '

    Record: '<record action="update"><value columnID="c0">O/S Documentation Set - English</value><value columnID="c1">00108</value><value columnID="c2">185.00</value></record>'


    -----------------

    I am trying to update physical table and column C_SALES_FACT.SALES based on the column C_SALES_FACT.COMP_KEY. The update statement specified in the xml template was running fine in TOAD.

    Do I am doing some mistake in specifying the SQL statement...
    <update> UPDATE C_SALES_FACT SET SALES = @{c2} WHERE COMP_KEY =@{C1} </update>


    Please provide some inputs. Thanks in Advance


    Best Regards
    Siva
  • 12. Re: OBIEE writeback
    577516 Expert
    Currently Being Moderated
    you have not used lowercase c. =@{C1} should be = @{c1}

    also since datatype is char you need to use quotation mark , eg
    '@{c1}' and make sure you do not input characters for number columns.
  • 13. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Thanks Joe and mma1709,

    The report is runing fine now with the writeback functionality. Thanks for your inputs and support.


    Best Regards
    Siva
  • 14. Re: OBIEE writeback
    sivausin Newbie
    Currently Being Moderated
    Hi Joe and mma1709,


    The writeback functionality is working fine, but I am curious about couple of questions regarding it.


    Q1. Can I update more than one column for a single physical table in the back-end database.

    Q2. Can I update more than one table, i, e If I have star schema, is it possible to make an update on two tables at the same time.

    Q3. Continution to Question 2.. Can I give multiple update statements in my XML template file.


    Thanks and Regards.
    Siva
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points