1 Reply Latest reply on Aug 9, 2016 4:46 AM by lenaic.ridinger

    SSAS translations and ordering of dimensions on the data pane

    i vittal

      Hi,

       

      We have translations for dimension names on SSAS cube for English and German languages. Tableau loads the translations correctly by while ordering the dimensions on the "Data" pane on the left of a workbook it does not order alphabetically.

      On the data source tab the field sort order is "A to Z ascending"

       

      For example, consider 2 dimensions (with remote names) Hospital and Pharmacy. By default the display order is as below

      - Hospital

      - Pharmacy

       

      When the locale is  "German (Germany)" translations are loaded correctly as "Krankenhaus" and "Apotheke". The dimensions are displayed in the following order:

      - Krankenhaus

      - Apotheke

       

      But they need to be ordered alphabetically i.e. Apotheke should be before Krankenhaus

       

      Please, is it possible to order them by translations provided for different locales rather than the remote names?