How to search/ filter two columns with single Table Prompt in OTBI analysis

Problem:

There is a business requirement to search Bank Account Number (which can be set up either at Customer Account level or Customer Site level) using single Table Prompt in OTBI analysis.

Solution:

In OTBI analysis, there is a feature of "Presentation Variable" using which this requirement can be achieved. Please follow below steps:

1. Add necessary columns in OTBI analysis including Bank Account Number at Customer Account Level and Site level
2. Setup a filter on both Bank Account Number columns » Add More Options » Select Presentation Variable » Keep Value as blank » Provide a nickname in Variable Expr. Please note that this