Analytics Software

Dears,

I am running an exercise to restrict all available data in my table based on current day of month (less than or equal to), what I am having a trouble in is that when I create a variable in prompt (just to test the query) the below sentence works where when adding it the Criteria body an error happens:

SELECT DayOfMonth(CURRENT_DATE)-3 FROM  "Anysubjectarea" (it works)

but the below won't:

Error getting drill information: SELECT  Month("DIM_TIME"."MONTH") saw_1, Day("DIM_TIME"."DAY") saw_2 FROM "AGGR_REVENUE" WHERE ("DIM_TIME"."YEAR_ID" IN (2014, 2015)) AND (Day("DIM_TIME"."DAY") <= (SELECT DayOfMonth(CURRENT_DATE)-3 FROM "AGGR_REVENUE"))

any help?

Moreover, I have no rich experience in OBIEE, is not there any place to test the query before applying it? If it's a product of ORACLE, why Select sysdate from dual is not working work???

P.s: I have no access to create a repository variable