Tabular translations

The Analysis Services OLAP engine in Tabular mode has some missing features compared to the Multidimensional mode. The Tabular engine is used in Analysis Services on-premises, Analysis Services Azure and Power BI (desktop + cloud)

Among the features that Tabular mode doesn't replicate are

• Member translations
  • This allows a multilingual display of a report based on the user.
  • For example, an English speaker would see Bikes and a French speaker would see Vélo.
• Member Keys, separate from the member Caption
  • This allows reports to be built with member selections maintained when a Caption changes.
  • If you update a Caption in tabular mode and have a report filter containing that member, then the selection will no longer work.
    • In Power BI, the old caption will be used, and the report will contain no data.
    • In an Excel PivotTable, the selection is lost when the data is refreshed, and the default (All) member is displayed instead.

The Tabular Translations feature in Anaplan XL aims to fix both problems. It lets you create a single report that can be translated into many languages and works well when member captions are changed.

Note this won't affect other front-end solutions such as Power BI or Excel PivotTables. You will have to use other translation strategies for those tools.