MicroStrategy ONE
Add translation statement
Adds a translation to an object.
ADD TRANSLATION TO translation_object_type "object_name" IN FOLDER "object_location_path" SET "translation" FOR FIELD [NAME | DESCRIPTION | ALIAS] IN LANGUAGE
("language_name" | ID language_id) IN PROJECT "project_name";
where:
-
translation_object_type is the type of object for which a translation is to be added, from the following list: FOLDER, CONSOLIDATION, DOCUMENT, FILTER, METRIC, PROMPT, REPORT, SEARCH, TEMPLATE, ATTRIBUTE, FACT, FUNCTION, HIERARCHY, TABLE, TRANSFORMATION, DRILLMAP, SECFILTER, AUTOSTYLE, BASEFORMULA, INTELLIGENTCUBE, DERIVEDELEMENT.
-
"object_name" is the name of the item you are adding the translation for, of type string.
-
FOLDER "object_location_path" is the path to the folder containing the item you are adding the translation for, of type string.
-
SET "translation" is the text of the translation you are adding, of type string.
-
FIELD is the portion of the field you are adding the translation for, from the following: NAME, DESCRIPTION, ALIAS.
-
LANGUAGE identifies the language this translation is part of, from one of the following:
-
"language_name" identifies the language by name, of type string.
-
ID language_id identifies the language by its ID, of type integer.
-
PROJECT "project_name" is the name of the project storing the item you are adding the translation for, of type string.
Example
ADD TRANSLATION TO FOLDER "Reports" IN
FOLDER "Public Objects" SET "Reportes" FOR FIELD NAME
IN LANGUAGE "Spanish (Spain)" IN PROJECT "MicroStrategy
Tutorial";