Skip to Content
0
Feb 24, 2023 at 03:15 PM

Make Free hand SQL number be dimensions rather than measures

431 Views

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.