I have a table made up of with a valuelist dimension, but not every set of expressions are needed for each value in the valuelist. Currently when displaying, I am getting a '-' in the columns that are empty.
Any way of removing this?
In the script catch all the NULLs
And before FACT table say
MAP "*" USING Map_NULLs;
UNMAP "%*"; //% will be fields you which to exclude from current selection box