MicroStrategy ONE

List translation statement

Lists the translations of an object.

Copy 
LIST TRANSLATION FOR translation_object_type "object_name" IN FOLDER "object_location_path" IN PROJECT "project_name";

where:

  • translation_object_type is the type of object you are listing the translation for, 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 listing the translation for, of type string.

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

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

Example

Copy 
LIST TRANSLATION FOR FOLDER 
 "Reports" IN FOLDER "Public Objects" IN PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

LANGUAGE: The name of the language, returned as a string.

LANGUAGE_TYPE: The type of the language, such as "MicroStrategy Metadata" returned as a string.