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..
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
i used OR India OR USA, it executed but again i got Boolean error.
Hi,
Just use the 'in' operator in your filter expression
eg
[Your Country Query Item] in ('India','USA')
Regards,
MF.