Multiple keywords in single OTBI column filter
The client is building some OTBI reports and would like to include multiple keywords in one column filter by typing the text in and not selecting values from the drop-down since 'Hardware' currently does not exist.
However this isn’t resulting in any results even though there are rows where org level 2 contains Home.
Can you advise how they can include a keyword any future results or additions are included in the report as well?
For eg. The reason why they want to include Home or Hardware is in case the org level 2 doesn’t exist now but will exist in the future, the client wants rows with these keywords included.