Supplier Bank Account info: how to filter "Assignment Inactive On"

Liwen Chiu

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:

Liwen Chiu

Hi all,

Just to update on this so that in case anyone else got the same requirement, it can be resolved like this:

Using OTBI-Analysis instead of BIP-Report with subject area of "Supplier - Supplier Real Time" to achieve it. This is because in Analysis, we may do Filters on the Assignment Inactive Date (set to > CURRENT_DATE or being null).

Please refer to the screenshot, hope it helps: