Hide Blank row in Value Prompt

[joecog]

Hi,

I had a value prompt as below :-

Product
---------------------
(Blank)
A
B
C


How do I filter out the (Blank) row from the value prompt?
I had tried using detail filter as below but when run the report, still show out.

[Ori].[Product].[Product].[Product-Category Code] not in ('(Blank)')

Anyone come across this problem before?

Joe

[PRIT AMRIT]

I had tried using detail filter as below but when run the report, still show out.

Have you filtered your Report query or Value prompt query? I mean, you must have two queries. One for you Value Prompt and another one for your Report?

Apply the filter on the query your value prompt is point to.
trim([Ori].[Product].[Product].[Product-Category Code])<>'(Blank)'

See if it helps?

[cognostechie]

Try this -

[Ori].[Product].[Product].[Product-Category Code] > ''

and I dont knwo why you are using the Category Code for this.

[joecog]

Hi Prit,

I had create a detail filter for value prompt query and also report query
I had tried your expression but still not working.

The (blank) is still appear.

Joe

[PRIT AMRIT]

First, are you able to capture the value '(blank)'?
can you just create a simple report with [Ori].[Product].[Product].[Product-Category Code]. So the report would be showing all the Category Code including the '(blank)' value.

Now create a Boolean variable:
[Ori].[Product].[Product].[Product-Category Code]='(Blank)'

If yes: Background color is 'YELLOW'
    no: Background color is 'Blue'

and see if it works?

The whole point is first you have to identify the value and then apply  the same in your filter condition to filter it out.

BTW, as cognostechie said, I too found it bit weired why are you using [Product-Category Code], how your Code(key) contains blank values?

Thanks
Prit

[joecog]

Hi Prit,

Ya, I was able to capture the (blank) value.
It is part of the member under the mentioned hierarchy.

I had create a filter base on the MUN of the (blank) and now it is not showing anymore at the value prompt.

Thanks guys...
It's working now...

Joe