We are using BOXIR3.1 SP2 with SAP BI7.0.
Along with available values for perticular object when used as Prompt (either created as variable in BI Query or prompt in universe or in WebI report) shows # (Not Assigned values) for blank values available at source.
I need to remove this # value from list of values of promts. I need to suppress or remove or hide this # value so that end user can not see this value in list of values of prompt.
One of possible solution is to creat the prompt in universe and hard code the available values in that prompt. But this approach will not be good for object with large number of list of values.
Is there any other way to remove # value in prompt?