Writeback user and date — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Writeback user and date

Received Response
131
Views
14
Comments
Jack
Jack Rank 4 - Community Specialist

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Robert Angel wrote: if you need that then look at using Apex.

    Amen

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You mean I can't use it as my ERP front end?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I'll get a ticket, come over and slap you. Would that work? :-P

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    let's meet in the middle ...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Last time an englishman and an austro-german met halfway between UK and Germany was....touchy

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Comedy gold the both of you...