Hi Experts,
Would like to reach out to you regarding the proper way of filtering Supplier Bank Account's "Assignment Inactive On" field.
Please refer to the screenshot that we are using Report with data source of Supplier - Supplier Real Time.
However, it's found that even if the supplier bank account is active, at the backend, some of the "Assignment Inactive On" is having values of 4712-12-31T03:56:14.498Z.
We would like the report to only keep active supplier bank acc. records, so I was trying to use "Filter" function, but may I reach out to you for your experience on managing this column: can the "Value" be a SQL script or function name like sysdate?
Currently, when I use a static datetime like 2024-09-10T23:00:00.000Z, it would accept. But it cannot be a static value, ideally, the active records would be the Assignment Inactive On value is greater than "today".
May I have your guidance on how to do the filter properly - or is it that we cannot use BIP with Subject Area as data source, such filtering can only be done in OTBI? (If using, how to achieve it?)
Thank you as always:
