matches pattern for multiple values
In Business Objects Query Filters, it is possble to say use an IN condition with multiple values
where country in list ('France', 'USA', 'Canada) etc.
However when we have to match sub-strings the matches pattern only allows you to input one value
This means, i cannot do
country matches pattern like ('%SA','Can%')
However such a contains functionality i am told by users exists in other BI products.
Can any one suggest any alternatives or work-arounds?