MicroStrategy ONE

Alter translation statement

Modifies the translation of an object.

Copy 
ALTER 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 changed, 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 changing the translation for, of type string.

  • FOLDER "object_location_path" is the path to the folder containing the item you are changing the translation for, of type string.

  • SET "translation" is the text of the translation you are changing the translation to, of type string.

  • FIELD is the portion of the field you are changing 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 changing the translation for, of type string.

Example

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