Translate Dimension Values (multidimensional)

• ramiz_dev

  SSC Rookie

  Points: 32

  More actions

  June 8, 2020 at 11:30 am

  #3761257

  Hello, is there a method to translate the values of a dimension?

  Example: dimension called diabetic with an IS_DIABETIC column and two values YES and NO I would like to do a translation in French of the values 'OUI' and 'NON' instead of YES / NO

  THANKS

• doug.brown

  SSCertifiable

  Points: 5608

  More actions

  June 8, 2020 at 5:54 pm

  #3761410

  A simple CASE expression would suffice for this, something along the lines of:

  CASE WHEN IS_DIABETIC = 'YES' THEN 'OUI'
  WHEN IS_DIABETIC = 'NO' THEN 'NON'
  ELSE 'Whatever you want your default to be' END