How to set as of now filter to OTBI:

Create veriable from prompt and set the prefix
as SET VERIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate'} this is case senstive
please make sure same prompt copy from prompt.