While designing your project, you not only need to consider your analysis and deliverable requirements, but it is also critical to consider who your audience is.
The multi-language functionality in Harmoni lets you engage with a global audience by allowing users to display the Harmoni interface, menus, and project items in different languages during their session.
In this article
- Designing the Project
- Language Sheet
- Upload the Language Sheet
- Selecting the Display Language
- Display Language
1. Designing the Project
When designing your project, it's important to consider the language of your data source. The project tree labels come from the data file labels. A Project Owner would typically design and label the project in the same language, although it is not required.
Learn more about project design and managing labels.
After designing your project, you can upload a language sheet containing the necessary translations for other Harmoni users to access. The project's default load language can be set with personalization keys. For more information, contact support@infotools.com.
The language used by the Project Owner when creating and designing the project becomes the design default. If other Creators or Explorers need to create their own constructions, they must use the original language.
2. Language Sheet
The language sheet identifies the items from the project tree that must be displayed in other languages.
You can create the language sheet in Excel using the following structure:
- The first row of the spreadsheet lists the different language options. These options become the selectors on the language dropdown.
- The first column of the file should mirror your project tree and contain the list of item labels that need to be translated.
- The first column should match the language used when designing the project tree.
- These items can include Axes, Elements, Headers, etc., and must be identical to Harmoni items without any heading/trailing spaces in the cell.
- This list can include all items from the project tree or a specific selection.
- You can include the English or local language name in the header, e.g., Spain or Español. Harmoni recognizes both, but displays the local language version. Ensure you include any diacritic marks used in the local language and remove spaces at the end of the word.
- You can use the subsequent columns to enter the corresponding label translations.
As a starting point for your language sheet, you can export all the labels in your project tree using export label structure.
3. Upload the Language Sheet
The project owner can upload, download, or remove the language sheet.
Translation of the project tree labels only applies to the item labels included in the language sheet.
To upload, you first need to navigate to the PROJECTS area. Click on the 3-dot menu and choose the option to upload the language sheet. Browse to the location of your language sheet file.
After the file uploads, the project tile will display a globe. This icon represents a Multilingual project. The 3-dot menu now displays the options to download and remove the language sheet.
4. Selecting the Display Language
After loading the project, the project tree displays in the default language. The default language can be set using personalization keys. Contact support@infotools.com for more information. The default language is English unless changed via a personalization key.
Select the appropriate option on the language dropdown to change the display language. The labels in the project and across the Harmoni interface are translated on the fly using a combination of online translation tools and the information from the language sheet.
The language selection is sticky throughout your session.
Data design options are only available when the project tree is displayed in the original language used to create the project.
Data Design
Data design options (i.e., design menu options, including creating new axes or measures) are only available when the project tree is displayed in the original language used to create the project.
Search functionality is available across all languages.
Languages Available
Harmoni translates a specific list of languages. Download the language list from the bottom of this article.
If the language you want is not available, please contact support@infotools.com to discuss your requirements.
5. Display Language
Analysis
When you create an analysis, the labels of the items defined on the language sheet display according to your selection. The Harmoni interface is also translated into the selected language. When you change the language, the analysis resets, so choose the language prior to beginning your analysis.
- Create an analysis
- Change the language
- The project tree and the Harmoni UI updates, but the analysis resets
- Recreate the analysis
Stories and Dashboards
Stories and dashboards inherit the selected language. The project labels are displayed as per their definition in the language sheet. You can change the language using the language dropdown.
Export to PPT and Excel
When exporting to PowerPoint or Excel, project item labels export using the selected language in the language dropdown.
- A story, created in Spanish, is exported to PPT
- The PPT export includes all the translated labels
- A single story view is exported to Excel
- The Excel table includes all the translated labels
Where to from here?
Learn more about Project Design.
- Project Design - Organize items in your Project Tree
- Project Design - Labels and Harmonization
- Project Labels - Bulk Relabel
- Project Design Interactive - Design menu