Question Re: Filter By Text in Technology Q&A

Filter By Text

Former Member — Thu, 08 Jul 2010 14:57:36 GMT

Is it possible to filter by parts of Text? I want to filter out any hr positions that have in the text the term "Casual". This could be a large number of positions and it could be a number of sequences in the text (e.g. Causual maybe the first word, second word or last word etc - it may also be in upper or lower case etc). So what I'd basically like to do is filter by Casual. Can this be done?

Re: Filter By Text

Former Member — Thu, 08 Jul 2010 15:11:49 GMT

There is no MATCH function (to use the Excel term) in BEx Analyzer.

You could do this in Excel itself or do you have Web Intelligence available as a BI tool?

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 03:37:38 GMT

Hi,

Are you asking after query execution?

then yes we can do that.

Go to select filter value for any chrecteristic and from pop up window click on arror at bottom "Display other values".

One more pop up wuill come. There you may select "Contains pattern" as "Casual".

I hope it will work.

Thanks,

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:19:48 GMT

Hi S,

This sounds interesting but I'm not sure what you mean by "After Query Execution"?

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:30:07 GMT

Hi,

I am trying to say.

When you have executed the query in Bex Analyzer (3.x). You right click on that charteristics and select "Select Filter Values" and there you may check for "Contain Pattern" option.

Thanks,

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:30:37 GMT

Do you mean putting a filter into, for example, the analyzer? Unfortunately I'm not actually outputting the field in my data. I just dont want any of thos positions with that text in my data. I'm looking at absence data by org unit and I dont want anyone with a position that contains the "Casual" text to be counted when I look at absenc. Other than that I'm not actually interested in the position so i dont output them.

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:31:09 GMT

Forgot to mention we are BI7 too.

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:48:57 GMT

Would it not be possible to create a variable in the query to filter by that has a customer exit and the exit we write then filters on the contenet of the text and removes and position texts that contains "Casual"?

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:57:41 GMT

Yes it is possible.

I was thinking on same line.

I guess it will work.

Just create one variable. Write exit to exclude pattern "*Casual".

Thanks,

Re: Filter By Text

Former Member — Fri, 09 Jul 2010 07:59:14 GMT

Time to speak to our ABAP'er maybe.

Re: Filter By Text

ulrikepfeiffer — Tue, 29 Mar 2022 13:49:46 GMT

I basically have the same question but would really like to have the filter option within the SAC Story and not in the Querry. Any possiblity to do so? BR