MicroStrategy ONE

Delete translation statement

Deletes a translation for an object.

Copy
DELETE TRANSLATION TO translation_object_type "object_name" IN FOLDER "object_location_path" 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 deleted, 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 deleting the translation for, of type string.

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

  • FIELD is the portion of the field you are deleting 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" is the name of the language, of type string.

    • ID language_id is the identifier of the language, of type integer.

  • PROJECT "project_name" is the name of the project that contains the item you are deleting the translation for, of type string.

Example

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