MicroStrategy ONE

Add translation statement

Adds a translation to an object.

Copy
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

Copy
ADD TRANSLATION TO FOLDER "Reports" IN 
 FOLDER "Public Objects" SET "Reportes" FOR FIELD NAME 
 IN LANGUAGE "Spanish (Spain)" IN PROJECT "MicroStrategy 
 Tutorial";