If possible, attach screenshot of the issue or share more details on your requirement.
1. Try to force is USE SET ORDER BY COLUMN, in THE LOGICAL TABLE PROPORTIES of BUSINESS MODEL AND MAPPING LAYER, "CHECK IN" the repository and
"Reload Metadata" in OBIEE Answers.
2. Put any column with number format at same level of data that you want to source, and HIDE this column in OBIEE.
If any these WORKAROUND doesn't solve the problem, please check your physical query:
Please put your user and in the repository inside go to manage-> identity -> Action -> Set Online User -> Enter the user that you use to test your result in Answers.
Open your report "Analysis", go to Administration-> Manager Session and check how the OBIEE SERVER create the QUERY.