I can input the “%” character in a prompt to select all values; however, this doesn’t work with one certain dimension - although it’s the same universe (but not the same tables) of dimensions with which I can use the “%” character in the same prompt…
The universe designer usually creates a pre-defined condition to check for the data to equal the value from the prompt, OR that ‘%’ equals what’s returned by the prompt.