Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Set operation failed due to incompatible sort order

Received Response
1
Views
2
Comments
SonPat99
SonPat99 Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:11PM in Oracle Analytics Forum

Dear GURUS,

I am using OBIEE 12.2.1.4.19X version.

I have created a Dashboard with a Variable Prompt and a UNION Report (Union of 3 reports).

I am trying to create a metadata search report based on Table, Table Name, Report, Subject Area, Report Column Name.

This works great when I am searching for a few strings as below:

pastedImage_0.png

However, this report gives an error when I am searching JE...

pastedImage_1.png

Also, there is NO Sort Order defined in the Union Report.

Request you to kindly help me.

Note: I have also referred a few other sites for the answer, but none of them worked.

There are no Measures used in the report as well.

Answers