We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issue

Accepted answer
29
Views
3
Comments
edited Apr 20, 2021 7:37AM in Reporting and Analytics for ERP 3 comments

Content

Hello There,

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!