LinkedIn
Twitter
Hello
we have in one of our tables a bunch of metrics for our products. as of now each metric is named as prodX_measure1. which means that we have a bunch of different permutations of products and measures.
I want to create a new dimensions called products, which have all of our product values, and then have each measure as a “regular” measure.
Essentially populating the new dimension PROD by each unique prod derived from the different metric names we have setup. and then matching the specific products measure to its corresponding dimensional value and measure.
How do I go about doing this ?
regards
Alex
