Skip to Content

How to Update the value of a field in DB from Webi Report using BO 4.2?

Hi All,

We have to update a field in DB by making an object editable from webi report.

We are going to use SAP BO 4.2

Whether commentary option in webi can be used to achieve this ?

Please pour in your thoughts or suggestions to achieve this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 08, 2017 at 07:30 PM

    Webi report you have created based on the DB fields for reporting purpose. Webi report will not update the DB field.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2017 at 08:34 PM

    Kamalesh,

    Quite interesting and theoretically this is possible too if you are planning to make use of commentary feature to write back to the database table though there is no out of box feature to achieve this directly. I would love to try this if time permits.

    You process will be something like below.

    • Configure the Commentary feature and make sure your users are provisioned to add comments to the WebI document.
    • Make sure the comments that you are adding in comment section is properly updated in commentary table
    • Create an external procedure that looks for an entry from commentary table and understands the target table& columns to be updated, condition to be met for update and finally approval any (Not everyone should be allowed to update)
    • Run the external procedure that reads your commentary database and update your target table.

    Thanks

    Mani

    Suggested reading: http://visualbi.com/blogs/business-intelligence/extending-bi-4-2-commentary-feature-audit-schema/

    Add comment
    10|10000 characters needed characters exceeded