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):