I can't find a way to make numbers in free hand SQL be dimensions rather than measures. I have numbers that are unique ID fields and primary or foreign keys. WebI is trying to aggregate them, causing a #multivalue error. Defaulting numbers to measures is a really stupid default if it can't be changed.
These fields are dimensions in my universes.
I know that I can make a variable and assign it as a dimension, but I need to be able to join/relate them to other objects where the data type is numeric.