How do I change value labels in a dimension?

[Anonymous]

Hi,

I have the individual brands for my company as a dimension in this chart, against the year's sales as an expression.  I'm trying to find out if there is a way to change the value labels on this dimension, so that instead of reading "T" and "S" etc, it reads the full names of the brands.  Is this possible?

Thanks

[Peter_Cammaert · Accepted solution]

If you want to keep script code changes few and small, add the Mapping table from Vishwarath's example here:Re: How do I change value labels in a dimension? to the end of your script, but omit the MAPPING Keyword and change the field names into Order Brand and Order Brand Name for example. Reload and change the dimension of your chart from Order Brand into Order Brand Name.

Best way is to add all possible Brands and their names to your INLINE table, as future loads may include data for additional products/brands that aren't present right now.

Best,

Peter