OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issue
I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and this does not work.
Added a filter on 'Accounting Period Name' as below, and this display rows that are not within this range:
"Time"."Fiscal Period" BETWEEN 'Jan-2021' AND 'Mar-2021' (snapshot attached)
I tried using the logical SQL in BI Publisher and it is the same result. (sample in the code snippet)
Has anyone come across such an issue and how this could be resolved both in OTBI and using the logical SQL in BI Publisher as well?