Set Filter to a Dimension Value ?

building reports webintelligence
1

Hi guys

I have a Block Result table with a filter on it.

I need the filter value to be set to a Dimension I created which is basically the User Response in the Prompt.

As far I can see a filter can only be set to:

(a) a constant
(b) a value from the list

Is there any way to do this, i.e. to automatically set the Filter to the Prompt value?

Thanks in advance

moutaye :fr: (BOB member since 2009-04-07)

2

Hi Moutaye,

If I understand you correctly, this is how I would do:

Create a variable

var1: If([Object]=Userresponse(‘Enter the text here’);1;0)

and I would use this var1 in you block filter and set it to 1
i.e. var = 1

izak004 :us: (BOB member since 2010-11-10)

3

Sounds like a plan.

I’ll try this tomorrow.

Thanks Izak

moutaye :fr: (BOB member since 2009-04-07)

4

This is working superbly. Thanks.

moutaye :fr: (BOB member since 2009-04-07)