Cube and dimension translations

Cube translations are stored in the extended properties of a cube in XML format.

In the Edit Database dashboard, select a cube. In the Advanced section of the Properties pane, you can edit the XML. For example:

<Alea:Properties xmlns:Alea="http://www.misag.com">
  <Alea:Translation LocaleIdentifier ="3079">
    <Alea:Description>Austrian description</Alea:Description>
    <Alea:Caption>Austrian caption</Alea:Caption>
  </Alea:Translation>
  <Alea:Translation LocaleIdentifier ="7">
    <Alea:Description>German description</Alea:Description>
  </Alea:Translation>
</Alea:Properties>

Dimension and level translations are stored in the extended properties of a dimension in XML format.

In the Edit Database dashboard, select a dimension. In the Advanced section of the Properties pane, you can edit the XML. For example:

<Alea:Properties xmlns:Alea="http://www.misag.com">
  <Alea:Translation LocaleIdentifier="3079">
    <Alea:Caption>Monat - Caption</Alea:Caption>
    <Alea:Description>Österreichische Monatsnamen</Alea:Description>
    <Alea:LevelCaption Level="0">Jahr</Alea:LevelCaption>
    <Alea:LevelCaption Level="1">Quartal</Alea:LevelCaption>
    <Alea:LevelCaption Level="2">Monat</Alea:LevelCaption>
    </Alea:Translation>
  <Alea:Translation LocaleIdentifier="7">
    <Alea:Description>German description</Alea:Description>
  </Alea:Translation>
</Alea:Properties>

Editing the XML in the advanced properties and saving the changes does not change the XML directly in the OLAP database. Instead the XML is sent as an XML request to the OLAP database.

Keep these points in mind when changing or deleting a translation:

  • When you change an existing translation, the translation is updated.
  • When you delete an existing translation, the translation is not updated, it remains in the database.

Translations can be removed by sending an XML request containing an empty translation tag. For example:

<Alea:Properties xmlns:Alea="http://www.misag.com">
  <Alea:Translation LocaleIdentifier="1029"/>
</Alea:Properties>