obiee entire column needs to be updated at once

Question

Hi ,

OBIEE entire column needs to be updated in write back and not one by one or row by row

User_5TGU6 · Answer

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

Robert Angel · Answer

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.

cesar.advincula.o · Answer

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..