OTBI Report as on effective date
Summary:
Want to generate OTBI report as on effective date other than sysdate
Content (required):
We have a requirement to fetch data as on 1 day before the current date, we used following expression in OTBI report in Prefix under Advanced tab. It errors.
SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}{TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE)}';
When the same is done using the hardcoded date as below, it works.
SET VARIABLE PARAM_EFFECTIVE_DATE='2023-06-22';
Please advise if there is any syntax issue in the above expression
Version (include the version you are using, if applicable):