2 Replies Latest reply on Sep 27, 2011 6:09 PM by user248025

    reg:filter operator in is not like

    875299
      hi,


      can anyone tell how does the filter operator "is not like pattern" function in obiee answers?in what scenarios this operator might be used/


      thanks
        • 1. Re: reg:filter operator in is not like
          Dpka
          Hi,

          "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.

          Rgds,
          Dpka
          • 2. Re: reg:filter operator in is not like
            user248025
            Hi,
            Filter:
            Its used to filter data from report.We apply filter on report as prompted to make prompt effective.
            Example :
            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

            Thanks

            Deva