General OBIEE

Get Involved. Join the Conversation.

Topic

    Matthew Voss
    Current Timestamp Not Updating on OTBI ReportAnswered
    Topic posted October 19, 2018 by Matthew VossGold Medal: 3,500+ Points, last edited October 19, 2018, tagged Core HR, Fusion, OBIEE Answers, OTBI, Reports, Scheduling or Agents 
    260 Views, 8 Comments
    Title:
    Current Timestamp Not Updating on OTBI Report
    Content:

    Hello,

    I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was hoping to run an agent every minute to pick up any changes in the last minute.  I am trying to use the below filter, but when I run the report the CURRENT_TIMESTAMP does not update every time the report/agent runs. When I run the report normally it has the Timestamp of the last time I edited the report, but if I refresh on the bottom of the report it will pull the current timestamp. Below is the filter I'm trying to use and the HCM Post I created, I've also attached the related XML.

    Does anyone have any advice on how to make the current_timestamp update every time the report is run or scheduled to run?

    Filter

    "Assignment Event Details"."Assignment Creation Date" > TIMESTAMPADD(SQL_TSI_MINUTE, -1, CURRENT_TIMESTAMP)

    HCM Report Post

    https://cloudcustomerconnect.oracle.com/posts/cea6e1d921

    Best Comment

    Richard Chan

    try 

    @{system.currentTime
    

    Comment