Hi
I am trying to support multilanguage in my reports by prompting the user to select a preferred language and using the prompt value showing different static text.
Now the question is , is it possible to capture the default language selected in the infoview preferences for the user and thus using it instead of prompting the user to select a language.
Also other approaches for multilanguage support which you think is better than the one i have used.
Hi,
We implement this by creating language table. Language ID is key field which is mapped to table say Business_Unit. This Business_Unit table holds English description and Language table hold multilingual equivalent values. In our case we consider English as default language. On user input report display different languages.
Exception
Suppose user select Simplified Chinese, which is null in table then display English.
Hi Milind
ya if possible pls share the details.
The method looks good but if i get your method correctly then isnt that for every static text of the report you create a separate entry in business unit table and language unit as well.
Also let me know for a particular report how do u fetch the preferred language content from this language table.
I mean when you refresh the report and assuming user has selected French as preferred language then , how the language table is brought in the query.
Or do you bring the static report content in a second query ?
Hi Basy, Kirann
Separate entry is necessary for each static text of the report. Business Unit table hold default English language descriptions. Language text is fix hence we created lookup table for searching and using case statement pull the required language description from catcode lookup table.
The above is example of Business Unit.
Apart from that we are using JDE as source which has UDC table which is used for soft coding. Also we want to display these values in multilingual manner.
Milind,thanks for your reply but still your explanation does not help me as iam still unclear of your approach.i think i need some more clear explanation.
Let me update my status in this requirement of multilanguage support of webi reports.
I and my teammate(deepak) tried to solve it from the sdk level.
1.Traced the jsp page where the prompts are being set.
2.Used resource bundle and a nl_properties file where we defined the prompts in the desired language (dutch in our case).
for example: enter_the_test=enter de test
3.When ever the user session locale is nl_NL the prompts are being picked up from the specific properties file.
4.The english prompts are displayed in dutch language.
So the first step of handling prompts translation is completed.
the second step is report headers translation - a if else statement at the report level by checling the locale(webi has getlocale function)has been used to handle this feature.
The only and the biggest hurdle is to handle the translation of drill down objects.
presently working on it.
once the jsp coding is tested thoroughly i would upload it in the upload section.
I would ask all the gurus to check whether my approach is the right one or does it have any implications.also how to handle the drill down objects translation.
PS:for our clients the requirement is to see the reports in dutch if he changes his locale to dutch else in english.This approach is followed keeping this requirement in mind.
Your’s requirement is different as compare to our requirement.
In our case all BO prompts are in English language. As per user response display text language is changed which is available in database itself.
We have not use any SDK feature for our implementation.
Hi Milind,
We are planning to have the report display in different languages based on the selection prompt. Do you mind sharing the detail steps needed to achieve this. Thanks for your help in advance.
Regards,
Passi
Hi Passi,
Basically we are interested to display some accounting report in multilingual fashion.
These reports show actual Vs planned figures against certain accounting heads and we manage to show these accounting heads in multilingual manner.
These accounting heads consist of unique ID.
Separate table was designed to store multilingual information say Language_Tab.
This table is populated by adding a single record for each required language.
Post-ETL script was designed to populate this table.
Fields below in Language_Tab forms the composite key.
[list]Account ID Unique number assigned for each Account head
Account Desc To store multilingual information
Language ID - To identify unique language[/list]
As per user response this table will return unique set of records for each language.
Apart from that we successfully implemented to display report header along with some other label in multi-lingual manner.
I can give you best suggestion if you can provide exact requirement.
It has been some time after the last post. But I got the same requirement here. I have to display labels of columns in report header according to user preference. Difference is that I am using crystal report on universe but not Web I.
Can you explain more on how to return the label desc at report level?
As per user response this table will return unique set of records for each language. If I got 10 label headings to be displayed on the report, the table will return 10 rows and if the report itselfs’ record set is 100 rows, the final record set would be 10 * 100. How to handle this?
Another problem is, every report gots their own labels to be displayed. Are those labels to be defined at report level or we need another database to store report ID vs label ID information?
(BOB member since 2005-11-11)