BusinessObjects Board

Prompt: %

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 “%” is nowhere defined in the universe.

Where is the problem?

Thanks!


SFL (BOB member since 2007-06-15)

Percentage (%) sign is actually a dummy character defined in prompt. This thread shows an example for ‘*’.
https://bobj-board.org/t/15227/2


BO_Chief :us: (BOB member since 2004-06-06)

Can you show it with an illustration
Why its not working, any error etc and the syntax

.


haider :es: (BOB member since 2005-07-18)

Where can I find this definition? I checked the joins, objects,… where is this normally defined?


SFL (BOB member since 2007-06-15)

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.


Anita Craig :us: (BOB member since 2002-06-17)