Unexpected Language Variation in Data Extraction - BIP Report

AM HRE · March 20

Hi community,

We are experiencing an unusual behavior with the "Environment Health and Safety - Incidents Real Time" subject area in a BI Publisher (BIP) report regarding the language of the extracted data.

We have created a BIP report that links a data model to an Oracle BI EE dataset. The data model contains a very simple sample query, as shown below:

SELECT     
0 s_0,
"Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Case Number" s_1,
"Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Injury Mechanism" s_2  
FROM "Environment Health and Safety - Incidents Real Time"  
ORDER BY 2 ASC NULLS LAST, 3 ASC NULLS LAST FETCH FIRST 250001 ROWS ONLY

When executing the report, the extracted data in column s_2 ("Injury Mechanism") randomly changes language between executions in the same session, even though the user's language setting remains unchanged.

The user executing the report is logged in Italian, and the extracted data alternates randomly between Italian and English, with no apparent reason.

This issue seems occurs only in a BIP report or when visualize the data in a data model associated with it.
However, the same SQL query, when run in an OTBI analysis, does not show this language-switching behavior.
Additionally, when executing the physical layer SQL query derived from the logical query, the issue does not occur either.

What could be causing this behavior?

Is there any setting or caching mechanism affecting the language in BIP reports but not in OTBI analyses?

Thank you!