Filter By Text

[Former Member]

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?

[ulrikepfeiffer]

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

[Former Member · Accepted solution]

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,

S

[Former Member · Accepted solution]

Hi S,

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

[Former Member · Accepted solution]

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,

S

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Forgot to mention we are BI7 too.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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,

S

[Former Member · Accepted solution]

Time to speak to our ABAP'er maybe.

[Former Member]

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?