Symptom
-
A SAP HANA analytic view returns data in two languages (i.e. French and English). An Analytic Privilege filters data according to the user language, which is defined using SESSION_CONTEXT('LOCALE') variable to get the language of the HANA session.
-
In Lumira, the data is always presented in English, even if the Lumira language is set to French. It seems that the SAP HANA session is always opened in English, regardless the language set in Lumira preferences.
-
In SAP HANA Studio, when opening a session in French (session connection, right-click > Properties > Additional properties > Connection - Locale) the data in French is obtained.
Environment
- SAP Lumira Desktop 1.x
- SAP HANA DB
Cause
- Lumira does not currently support HANA Session Locale.
- The Product Owners are discussing this as part of an epic to add connection parameters to also support things such as multiple databases added in HANA SPS9.
- No delivery timeline has been set.
Resolution
- Enhancement request has been created in Idea Place (KBA 1515837), as follows: Support HANA session language in Lumira desktop (D22693) - https://ideas.sap.com/SAPLumira/D22693
Keywords
locale localisation localization , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem