SAP Webi 14.0.6 "Cannot Use Matches Pattern"

building reports webintelligence
1

Not sure what sub forum to post this on, so if Admin needs to move please do.

I am using SAP Webi 14.0.6 and trying to filter on certain columns for a Matches Pattern. When I go to Filter on my primary column [Summary] in my list of operators I don’t have Match, or Matches Pattern… Was this removed from this version of BO?

My thoughts are I could just make a custom variable. But this is where I’m struggling. So far I’ve tried matching anything with the words “test” in [Summary], but no success

=If MATCH([Summary];("%test%")) Then “Y” Else “N”
=If MATCH([Summary];(“test”)) Then “Y” Else “N”
=If MATCH([Summary];(“test”)) Then “Y” Else “N”
=If(MATCH([Summary];("%test%")) )Then “Y” Else “N”
=If(MATCH([Summary];(“test”)) )Then “Y” Else “N”
=If(MATCH([Summary];“test”);“Y”;[Summary])
=If(MATCH([Summary];“test”);“Y”)

So far all formula’s above are valid, just not correct. They either produce just a ‘N’ value or display the full value for that column. Not sure where to turn to from here. Everything I’ve searched so far is pointed me to the formula’s I created above

doctorj77 (BOB member since 2015-04-08)

2

Shouldnt each branch be:-

If MATCH([Summary];"%test%")Then......etc

Mak 1 :uk: (BOB member since 2005-01-06)

3

I tried that too

=If MATCH([Summary];"%test%") Then “Y” Else “N”

Just produces ‘N’ for every row, even though some of those rows clearly have the word ‘test’ in [Summary]. I wasn’t sure if it was case sensitive either since most of the values in that column are in caps. But tried it both ways and nothing still.

doctorj77 (BOB member since 2015-04-08)

4

Hi,

What does this formula return for those rows?

=Pos([Summary];"test")

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

I think that did it

So it returns the position # of the matching ‘case sensitive’ value. If it doesn’t contain a matching value, then it just displays ‘0’.

So I think its simple enough, all I have to do at this point is filter [Summary] Not Equal to ‘0’

doctorj77 (BOB member since 2015-04-08)

6

That’s correct.