I am trying to build an automation process where my report will get updated based on a variable.
I am setting the variable using a sql script:
Case When DD.(MSP_DT) = TRUNC(SYSDATE-1) THEN 1
END AS DateCheck
From Schema.Table DD
I am having an issue where it is saying no connection…and I am connected to the database… Any help?