Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Created by Guest
Created on Dec 13, 2023

Translation: use default language in reports if system language not available for reports

Currenty if adding the feature multilanguages we has two possibilities:

1) Using the following formula:
=PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage)

I translate the text in german and french. My default language is english.
If a user enters the system with a spanish user setting, with the formula above this user will see no text. Half empty reports. view screenshot.

2) Using the following formula:
=IF(PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage)="",PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";"~"),PALO.DATAC(rngDB;"#__Translation";"Name";"1000130";rngLanguage))

This means everytime a user opens a report all text will be requesting: does the text exists? if yes please show. It creates unnecessary traffic as the user can switch multiple times between reports.

As we are using the formulas in all places where are texts (title, subtitles, row and column titles, chart titles, etc.) it takes performance.

Therefore my request: we would like to use the shorter more efficient formula 1 and if the text does not exist, jedox should please show the default language ("~").