Create a dimension in script for every field

[markgraham123]

Hi All,

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

Here is the Example:

Product A Units	Product B Units	Product C Units	Product D Units
100	200	300	400

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.

[swuehl]

Hi Mark,

the concept is explained in detail in the referenced blog post by Henric.

You cannot use a preceding LOAD or LOAD prefix on top of the CROSSTABLE LOAD, so you would need to use a subsequent RESIDENT LOAD for further transformations or field manipulations.