Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
obiee entire column needs to be updated at once
Hi ,
OBIEE entire column needs to be updated in write back and not one by one or row by row
Answers
-
Hi,
you probably missed this, have a look: https://youtu.be/5CgBmj7Jz6Y?t=18s
0 -
Not the purpose nor intent of Write-Back ... OBIEE is not a data quality tool ...
0 -
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..
0 -
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.
0 -
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
0
