5 Replies Latest reply on Sep 19, 2013 4:34 PM by JuMae

    Repository variable and Init block

    JuMae

      I created an Init block that is based off of a sql command in which the command is designed to give me the max date a table was updated after a data load.  Well the variable I created based off of this has a timestamp of today's date.  I want to create a report on the front end (actually just a column) that updates when a load has been completed.  I use this (TIMESTAMPDIFF ( SQL_TSI_MINUTE, VALUEOF(“LAST_UPDATE_DATE”)), CURRENT_TIMESTAMP)) for the column formula but I'm either running into errors or getting nothing at all.

       

       

       

      OBIEE 11.1.1.5

       

      Please Advise