Translations don't work in Excel

Question

Dear,

I have built a sales cube but I cannot get the translations to work.

Here is my setup:

I have saved my SSAS Project, deployed and processed.

Answer 1

Also my Excel is configured completely in Dutch on the test pc.

Answer 2

Neverthless, the field is showing up in English instead of Dutch. 

What am I missing?

any help is very much appreciated.

Answer 3

Hi ChristianBoeur,

Thanks for your question.

Firstly, please make sure that all items in your translation are filled and there are no "untranslated" display folders etc. left.
You can verify that through browsing the cube by using translations. On the toolbar, select the language you want in the Language list.

If everything seems fine, You might want also try to set Region(including Formats, Location and Administrative) to Dutch on your workstation.

If this still not work, you will have to use locale ID in the ODC(LocaleIdentifier=1043 ).
See below blog talking about this issue.
https://jetsupport.jetreports.com/hc/en-us/articles/219400927-Changing-the-Locale-Identifier-in-Excel-to-See-Other-Language-Translations

You can find Language identifiers  in below document:

https://docs.microsoft.com/en-us/deployoffice/office2016/language-identifiers-and-optionstate-id-values-in-office-2016

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 4

Dear Yuan,

Thanks for your reply.

It looks ok in the Visual Studio browser,

It just doesn't work in Excel, there it remains in English.

Answer 5

Hi,

Please locate the .odc file in your data sources and open in notepad. Please add the below keyword under <odc:connection string> after intial catalog = <cube database name>; Locale Identifier = 1043 and save the file.

Then open a new workbook pointing to the newly modified .odc file and you should be able to see the translations.

HTH,

Ram

---

Please vote as helpful or mark as answer, if it helps

Answer 6

Hello Ram,

Thanks for your reply.

Its working now, I had to use "Locale Identifier=2067" for nl-be.