10 Replies Latest reply: Aug 16, 2016 2:36 PM by Stefan Wühl RSS

    Create a dimension in script for every field

    Mark Graham

      Hi All,

       

      I'm trying to create an individual name in a dimension for every field.

      Here is the Example:

       

        

      Product A UnitsProduct B UnitsProduct C UnitsProduct D Units
      100200300400

       

      I'm trying to create a new dimension which would have names of the Product mapped to its units value.

       

                                New Dimension

      Product A Units    A

      Product B Units    B

      Product C Units   C

      Product D Units   D

       

      I did it in the front end using Value list , Pick Match.

      But i'm trying to do it in script so it can be simple on front end chart.

       

       

      Any help is highly appreciated.