This content has been marked as final. Show 2 replies
"is not like pattern" operator is used in those scenarios where you need to eliminate a string pattern in the result set .For instance if a particular column has value as 'obiee' in any part of the string and if you want to eliminate those strings that contain 'obiee', you go for "is not like pattern" option.
Its used to filter data from report.We apply filter on report as prompted to make prompt effective.
ColumnA is prompt then we apply filter is not like ('India','Singapore') then the report will display expect india and singapore country in the output the report as ColumnA is prompted
Filters can be apllied on report in many with diff operators like not equal In order to select values dynamicaly from report and filter data from report we use prompt.
Prompt - Its used to select specific values to be filtered from the report