Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Writeback user and date
Hi
We have a requirement as to writeback data to DB table and also we have to write back data to table as who and when that data has been inserted or updated
How we can audit who and when writeback data from a report and date in obiee 11g
Answers
-
1.) "report" is BI Publisher and not OBI. An "analysis" is OBI. Two totally different technologies. Two totally different objects!
2.) Why not just put the USER variable into a column? VALUEOF(NQ_SESSION.USER)?
3.) For the date...NOW()?
Just look at what OBI has. All of this is there since more than a decade.
0 -
The syntax is no different to a stand insert statement, hence as Christian rightfully says you can reference OBIEE variables (for the user) and database variables sysdate or the local equivalent in the db you are writing back into.
Don't make the mistake of trying to build full form functionality with writeback, if you need that then look at using Apex.
0 -
Robert Angel wrote: if you need that then look at using Apex.
Amen
0 -
For me, others may see it otherwise, Writeback stands out as the single most disappointing feature of OBIEE.
I remember the original literature back in 10g days, then the implementation, very limited.
It is useful for very limited requirements, like writing back free text comments for things like variance analysis, but any more than that and I would not go there. Ever.
0 -
Of course. It never was meant as more than a "we have it, it exists" type of sales argument.
Unfortunately then people went and tried using it like a web application for data entry
0 -
You mean I can't use it as my ERP front end?
0 -
I'll get a ticket, come over and slap you. Would that work? :-P
0 -
let's meet in the middle ...
0 -
Last time an englishman and an austro-german met halfway between UK and Germany was....touchy
0 -
Comedy gold the both of you...
0