Adding Filter some one help me...

[jayanthhyd]

I have 1 query how to restrict data in framewok manager??? suppose i have country dimension having many countries, i want only Records India and USA.


what i have done is in FW manager i tested Query subject, then i go to filter then i click add filter then i inserted country dimension = India. Its working fine but i want both india and usa. If i put comma USA its not working.

Can anyone please help me..

[jive]

HI,
I'm not sure but if you tell something like
country dimension = India or country dimension = USA
another possibility could be country dimension in (India,USA)
You can also edit the querry subject and insert the condition you want, if that condition have to be always applyed.

I hope this can help
Regards Jacques

[jayanthhyd]

i used OR India OR USA, it executed but again i got Boolean error.

[MFGF]

Hi,

Just use the 'in' operator in your filter expression

eg

[Your Country Query Item] in ('India','USA')

Regards,

MF.