Pyramid provides the capability to create various language models, facilitating the development of multi-language reports and dashboards. The attribute definitions for the translated language(s) must be stored in translation tables in the data source. Pyramid then allows users to map the translation attributes to the original language's attribute.
Note: The default language attributes must be checked in the model in order to be translated in the translations tab. Translation language attributes must be unchecked in order to be able to map them to the default language attribute.
The Attributes tab (red box) can be accessed from the Translations icon
Language: The selected languages appear in the multi-select Languages drop down (orange box below). Additional languages can be selected from the drop down.
Table Name:The Table Name filter (blue box below) allows users to define the tables to be translated. By selecting "All" users can translate all columns for all tables at once, or they can select a specific table name to translate all attributes for a specific table only. Users can then only specify the tables that require translation. This simplifies the interface by only displaying attributes requiring translation.
Translation Attributes: Users can select the attributes to be used for translation.
For example, in the DimProduct dimension, the attribute storing the product name is EnglishProductName.
The French translation of the product name is stored in the FrenchProductName attribute and the Spanish translation is stored in the SpanishProductName attribute.
In this example, the user selected the FrenchProductName and the SpanishProductName was selected from amongst the other options in the drop down (yellow box).
Note: In this example the column name EnglishProductName was selected (checked) in the columns tab and the FrenchProductName and SpanishProductName were both deselected (unchecked). Any other unchecked attribute will also appear in the drop down as a potential choice for the translation mapping attribute.