2 Replies Latest reply on Sep 28, 2016 5:14 AM by Stephan Hable

    Need Help -- Merge dimensions?

    Stephan Hable

      I have the following problem.I have a dimension (Test) with multiple attributes (strings). These attributes are separated by a comma. It looks like this:

       

      Test
      Joe, Tim, Kevin, Matt
      Tom, Liz
      George, Oliver, Sascha
      Tina, George, Brian, Nancy
      Matt

       

      I split the dimension Test into four dimensions. Now I have four dimensions (North, South, East, West) with attributes (strings).

       

      NorthSouth EastWest
      JoeTimKevinMatt
      TomLiz
      GeorgeOliverSascha
      TinaGeorgeBrianNancy
      Matt

       

       

      Now I would like to have a new dimension (Summary) from the four existing dimensions. It should include all the attributes of the four dimensions. Duplicates should be listed only once.

       

       

      Summary
      Joe
      Tim
      Kevin
      Matt
      Tom
      Liz
      George
      Oliver
      Sascha
      Tina
      Brian
      Nancy

       

      The four dimensions (North, South, East, West) are calculated fields. That´s why I can´t use pivot, right?

      The four dimensions (North, South, East, West) are dynamic. This means that every week new attributes can be added in one of the dimensions.

       

      Does anyone have a solution or an idea?

       

      Thank you very much