Oracle Analytics and AI

user5741487

When using WRITEBACK, can the OAC userid be captured and used in the XML template to store in the target table who made the update? If so, how is that specified in the XML template? Similarly, can we use sysdate in the XML template to store the timestamp of when the update was made?

GayathriAnand-Oracle

You can expose 2 additional columns in the report which are non-editable columns - one will have formula for USER session variable and other for repository variable (which would capture sysdate) and include these column ids or position in the insert template.