Looking to display my dimension values as text. Basically I have a Code 1,2,3 and want to display on reports as 1=Norway, 2=Sweden, 3=Zimbabwe in pivot chart.
However, here's the catch. I load my data from a QVD file, and there is a lot of data. Using ApplyMap in the QVD to recode dimensions with the text values means the QVD takes up 1000 times more space, and using ApplyMap in the associated QVW files means those files take up 10000 times more space and take 1000 times more time to load. I basically just want the display to appear differently on the reports with the underlying data still numeric.
Create a new table with the fields DimCode and DimText for all the DimCode.
If the name if the field for DimCode is the same both in your large QVD data table and in the new mapping table is the same, you can use DimText as your dimension in your chart.
