Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
3713479
3713479 Rank 4 - Community Specialist
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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...