Hi ,
OBIEE entire column needs to be updated in write back and not one by one or row by row
Hi,
you probably missed this, have a look: https://youtu.be/5CgBmj7Jz6Y?t=18s
Not the purpose nor intent of Write-Back ... OBIEE is not a data quality tool ...
dont understand the real objetive behind your question.. dont know why you need it because in think the objetive behind a write back there is something like a do particular update, not a update batch of records.. maybe for this particular thing you could use another alternatives like a action links (webservices, java method) which has more complex logic..
I would suggest what I have previously on write back, point write back at a view; simple or complex; use write back to effect the update.
On the database create a trigger on the view that will handle the update, which now can be as complex as you like and, because OBIEE is very crude for data updates you can also ensure the quality of data hitting your database, you have effectively written an API.
Alternatively as the other learned posters say, use java methods etc or an Apex form if that is more your skill set / and / or you don't have the luxury of being able to create views / triggers on the database.
US people wants automation..of the column for entire update of column once as they have set up script in db and it triger's emails to the user
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
I am getting a general error when my workbook's scheduled email tries to send out an excel file (See below error). I have tested and successfully send a scheduled email that sends a PDF - so I am wondering if there is an issue with sending excel files currently? It worked fine until this morning:
