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 allows you to speak to and engage with a global audience by allowing users to display project items in different languages during their session.
Personalization keys Keys that can be applied at the user, site (all users), or company (all users) level. Contact firstname.lastname@example.org for more information. are used to enable this feature.
In this article
- Designing the Project
- Language sheet
- Upload language sheet
- Selecting display language
- Display language - Analysis
- Display language - Stories and Dashboards
- Display language on export to PPT or Excel
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 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 email@example.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 items, 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 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 language sheet
The project owner can upload, download, or remove the language sheet.
Translation only applies to the project 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 will now allow downloading and removing 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 firstname.lastname@example.org 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 are translated on the fly using 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 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.
5. Display language - Analysis
When you create an analysis, the labels of the items defined on the language sheet display according to your selection. You can change the language on the fly using the language dropdown.
System variables do not translate as you change languages.
6. Display language - 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.
7. Display language on export to PPT and Excel
When exporting to PowerPoint or Excel, project item labels export using the selected language in the language dropdown.
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