Appreciate if you can help on the next step. I am not getting all the buttons. When I click on 'Update' then the field is enabled for edit. But I cannot edit the field. It is allowing me to edit the field at all. Below is the writeback template. I want to use generic columns like @{c1} etc instead of actual column id. We…

Our Admin missed the last step !!!

1. Setting the LightWriteback Element --> This is done and verified. No issue there. 2: You only can UPDATE or INSERT a 1 Table By --> I am not updating multiple tables. I am updating only 1 table and only 1 column. But the Columns pulled in presentation layer are from 3 different tables. Now typically, when OBIEE run SQL…

Thanks you for the suggestion about connection pool. The access error is resolved. Now I get following error - An error occurred while writing to the server. Please check to make sure you have entered appropriate values. If the problem persists, contact your system administrator. Below is the example I have. Please confirm…

Thanks for the input. This was completed. I am still getting the same error. Is it something to do with permission to the file or folder?

Hi All, Now I get following message from front screen - The system is unable to read the Write Back Template 'UpdateSupInfo'. Please contact your system administrator. Anything to be done about the permissions or writebacktemplate? Thanks

Great !!! Now other columns after WHERE clause also need to be database columns? They may be from different tables in database. In this case I changed the columns PO Number to PO_NUM, Item to SEGMENT1 and so on. But they are stored in different database table. <?xml version="1.0" encoding="utf-8"?> <WebMessageTables…

Hi, I was able to resolve this by using the lookups. I used dense lookup and I get the MAINTAIN_DATE as expected. Thanks

No MAINTAIN_DATE is NOT joined to any other table. The WORK_ORDER table is Fact table. Expected behavior is when we are pulling in the work orders data then we should be able to pull in the MAINTAIN_DATE. This is linked through the LINE_ID column.

Thanks for quick response. I just uploaded the Model diagrams. Please review and let me know input. Thanks

Perfect !!!! This was the one I was looking for ... Thanks a ton

Thank you very much for the input. I will study these suggestions and get back.