Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Writeback user and date

Received Response
133
Views
14
Comments
2»

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Well played!

  • Jack
    Jack Rank 4 - Community Specialist

    Thank You for your reply, Can i give user and data directly in writeback template as below

    <update>update table set c1='VALUEOF(NQ_SESSION.USER)' ,c2=NOW()</update>

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Christian Berg wrote:2.) Why not just put the USER variable into a column? VALUEOF(NQ_SESSION.USER)?

    ^--- Column

  • Jack
    Jack Rank 4 - Community Specialist

    we can use VALUEOF(NQ_SESSION.USER), but that column which i used in report is not able to enable writeback