2 Replies Latest reply: Mar 5, 2018 6:01 AM by Tamil arasu RSS

    Creating dimensions

    Sofia Vaz

      Hi all,

       

      I have a set of codes for different countries which I'd like to divide into groups in order to create a dimension called 'Office'. The field of these codes is called 'MarketCd'.

       

      If the code is 16 or 76, the group should be called 'UK+IR'. If the code is 92 or 93 the group should be called 'Overseas'. For all of the other codes, I want the dimension to create unique value sets which are named with the 'MktDescrip' that corresponds to that 'MarketCd'

       

      The table below may help you understand what I mean:

       

         

      MktDescripMarketCdOffice
      UK16UK+IR
      Belgium 15Belgium
      Portugal10Portugal
      France12France
      USA46USA
      Spain11Spain
      Ireland76UK+IR
      Asia92Overseas
      Oceania93Overseas

       

      Do you have any ideia how should I do This?

       

      Thank you!