cancel
Showing results for 
Search instead for 
Did you mean: 

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

kamalessh
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182521
Active Contributor
0 Kudos

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/

former_member185603
Active Contributor
0 Kudos

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