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
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.
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.
Robert Angel wrote: if you need that then look at using Apex.
Amen
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.
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
You mean I can't use it as my ERP front end?
I'll get a ticket, come over and slap you. Would that work? :-P
let's meet in the middle ...
Last time an englishman and an austro-german met halfway between UK and Germany was....touchy
Comedy gold the both of you...
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
If I only do one with one expression filter, it works, but if I put the 2nd parameter with an expression filter, I get no data found???? Why
