OBIEE query returns zero rows based on number of columns in select list

Question

OBIEE queries such as the one indicated below executed with no issues for months.  Following a recent reload of the table, the query returns zero rows unless the select list is expanded beyond three columns.

Customer ID = 123

Select List... Customer ID, Transaction-Date, Transaction-Code.

Gianni Ceresa · Answer

Hi,

You want to have a look at  .

Your post is maybe extremely clear for you as you spent 1-2 days looking into that thing, but remember that nobody here has your system in front (except if one of your colleague is on here).

The more effort you do to write your thread, the better the answers you get are...