Translations Panel

Multi-lingual modeling lets users translate the metadata that appears in content items (reports, dashboards, publications, and so on) as tables, columns, measures, hierarchies, and so on. You can translate labels manually by typing your translations into the appropriate fields, automatically using Artificial Intelligence, or (to speed up your translation but also assure quality) using a mix of both.

Note: The Multi-lingual modeling feature is available with an Enterprise edition license only. For more information, see Pyramid Licensing.

Configure Multi-Lingual Models

Open the Translations Page

The Translations option is not available in the Elements list by default, you must select Translations in the Configuration ribbon to enable it:

Translate Metadata

You can configure your multi-lingual model from the Metadata tab on the Translations page:

From the Metadata tab (selected by default):

  • Language: The languages (yellow box, above) that are supported for this model. This list is pre-populated with the languages that were selected in the model Configuration's Translation Languages field. You can also add additional languages, with each selected language adding a Translations column for that language to the table (green highlight).
  • Filter: (blue) Select to filter the different types of metadata (Global, Tables, and Measures) to limit the type of items to be translated. This allows users to define the metadata for each metadata type separately. For more information, see Filter (below).
  • Table: The main table defines the items that you want to provide translated labels for, the default labels for those items, and the translations:
    • Items: (red) The names of the items in the model whose labels may be translated. Includes the model name, description, column names, and so on. Which items are displayed is affected by the Filter.
    • Model Default: The default values for each of the labels. In our example, the default language is US English (en-US), so this column supplies the English language labels for the model items.
    • <Language>: (green) Each of these columns provide the translated labels for a particular translation language. You should define labels in the specified language columns either manually or using Auto Translate. If you do not supply a translation, the Model Default label will be used.

Note: You can only translate labels into a language that has been selected from the language drop-down (yellow box, above).


The filter drop-down (blue) selects the type of options you want to translate:

  • Selecting All leaves the item table unfiltered; that is, it displays all metadata types together. Note: The preceding example shows an unfiltered list of items; you can tell which type each item is from its prefixed icon.
  • Selecting Global (blue box below) allows you to define the translations for model name, description, and other global items (red box below). Note: Global types are prefixed with a globe icon (green arrow).
  • Selecting Tables (blue box below) allows you to define translations for the tables and columns and their descriptions.
  • When you select this option, a Table Name field (red box below) also opens. Select "All" from the Table Name drop-down to translate all tables and columns at once, or select a table name to translate columns for a specific table. Note: Tables and columns are prefixed with cell icons (green arrows)

  • Selecting Measures (blue box below) allows you to define translations for the measure folders, and the measures and descriptions for the tables.
  • When you select this option, a Table Name field (red box below) also opens. Select "All" from the Table Name drop-down to translate all measures and folders at once, or select a table name to translate all measures for a specific table. Note: Measure Folders and names are prefixed with folder and measure icons (green arrows)

    Tip: Formulas can be translated using the translate source feature in Formulate.

Tip: You can additionally filter the Items, Model Default, or <Language> columns to only include values that contain some or all of a given string. This is useful if you have decided to change a particular term that appears in many labels.

Auto Translate Metadata

The Auto Translate feature uses Artificial Intelligence to create translations for one or more selected languages. These translations are generated using a Large Language Model (LLM) through Pyramid.

Note: Your administrator selects the Large Language Model (LLM) to use for translations in the Admin Console's AI Settings page.

  1. The Auto Translate buttons automatically translate one of the following:
    • Click Auto Translate at the head of a column (red) to translate all of the labels from the Model Default column into the language named by the column.
    • Click Auto Translate alongside the item name (blue) to translate the label from the Model Default column into each language that has its own translation column in the row or rows.
  2. In each case, the Auto Translate pop-up opens (see following image):
    • Select Everything to generate a translation for all selected items with a Model Default value. This option creates new translations and replaces existing translation values.
    • Select Missing Values to generate a translation only for those selected items with a Model Default value that is currently empty. This option only creates new translations and ignores columns that have previously been translated.
  3. Check your translations, and Save your changes.

Tip: You can clear all of the translations for a particular language (column), or for a particular item in all languages (row), by clicking the appropriate Clear Translations button. This option clears the translations and not the Model Default values.

Other Topics

  • Click here to learn more about translations attributes in Model
  • Click here to learn more about configuring translations in Formula
  • Click here to learn more about translating dynamic text in Presentations